Re: [SQL] how to use pgsql like mssql

2007-12-26 Thread Pavel Stehule
Hello On 27/12/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > but i do not want use function or procedure > > wish this features > PostgreSQL doesn't support this feature. You can use procedural construct only in functions. Regards Pavel Stehule > > > > -

Re: [SQL] how to use pgsql like mssql

2007-12-26 Thread Pavel Stehule
On 27/12/2007, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > --- On Wed, 12/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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

Re: [SQL] how to use pgsql like mssql

2007-12-26 Thread Richard Broersma Jr
--- On Wed, 12/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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

Re: [SQL] how to use pgsql like mssql

2007-12-26 Thread liuzg2
but  i do not   want use function  or  procedure  wish this features

Re: [SQL] how to use pgsql like mssql

2007-12-26 Thread Richard Broersma Jr
--- On Wed, 12/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > in the pgadmin edit > i want use > declare ... > if exists ... > insert something if @@rowcout>0 then do something > if > like in mssql and not use function I take it that you are looking to create stored procedures? In

[SQL] how to use pgsql like mssql

2007-12-26 Thread liuzg2
in the pgadmin editi want usedeclare ...if exists ...insert something if @@rowcout>0 then do somethingif like in mssql and not use functionhow tosorry for my english