Re: how to use pgsql like mssql

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, liuzg2(at)21cn(dot)com
Subject: Re: how to use pgsql like mssql
Date: 2007-12-27 04:54:03
Message-ID: 162867790712262054l19481519icf55948220399598@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2007-12-27 04:55:55 Re: how to use pgsql like mssql
Previous Message liuzg2 2007-12-27 02:05:18 Re: how to use pgsql like mssql