Re: how to use pgsql like mssql

["Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>]

On 27/12/2007, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> --- On Wed, 12/26/07, liuzg2(at)21cn(dot)com <liuzg2(at)21cn(dot)com> wrote:
>
> > but  i do not   want use function  or  procedure
>
>
> Are you sure?  I thought that:
>
> DECLARE
> IF --control structures
> @@rowcount
>
> where only usable in a store procedure.  Am I incorrect, or are these keywords accessible from the SQL prompt?
>

You can use outside procedure in T-SQL.

Pavel

> Regards,
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>