Re: how to use pgsql like mssql - Mailing list pgsql-sql

On 27/12/2007, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> --- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.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
>