Re: [SQL] Advice for generalizing trigger functions

2007-12-26 Thread chester c young
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > I've created quite a few functions that log modifications to various > history tables. (the history table has the same name as the base > table but is prefixed by the 'History.' schema.) The only difference > between functions I can find is the

[SQL] need help

2007-12-26 Thread A. Wiryawan
is there any one online in yahoo messenger right now..? Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Re: [SQL] Advice for generalizing trigger functions

2007-12-26 Thread Richard Broersma Jr
--- On Wed, 12/26/07, chester c young <[EMAIL PROTECTED]> wrote: > what I do for change log is to have one change log table with table_id > and column_id attributes that refer by to my internal meta_table and > meta_column tables. this always works and is in the end, I have found, > a bit more fl

Re: [SQL] need help

2007-12-26 Thread Richard Broersma Jr
--- On Wed, 12/26/07, A. Wiryawan <[EMAIL PROTECTED]> wrote: > From: A. Wiryawan <[EMAIL PROTECTED]> > Subject: [SQL] need help > To: pgsql-sql@postgresql.org > Date: Wednesday, December 26, 2007, 11:19 AM > is there any one online in yahoo messenger right now..? I am not, but you can find alot o

Re: [SQL] need help

2007-12-26 Thread Richard Broersma Jr
--- On Wed, 12/26/07, A. Wiryawan <[EMAIL PROTECTED]> wrote: > niwey do you have any e-books abour postgresql to be > shared, if you don't mind please sent me Sure, There are lots of books on the Postgresql site: http://www.postgresql.org/docs/8.2/interactive/index.html http://www.postgresql.or

[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

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

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: > 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 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