Thread: Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000
Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000
From
"shreedhar"
Date:
Dear Momjian, I need solution for the problem stated in subject. (i.e.) any method to know whether a record is Previously updated or not ? Sreedhar ----- Original Message ----- From: "Bruce Momjian" <pgman@candle.pha.pa.us> To: "shreedhar" <shreedhar@lucidindia.net> Sent: Friday, December 27, 2002 10:41 AM Subject: Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000 > > Sure. As root, use the 'date' command to fix it. > > -------------------------------------------------------------------------- - > > shreedhar wrote: > > Sorry, > > > > Because it is some problem in my system. So, it has shown Fri, 15 Mar 2002 > > 17:27:30 +0530. > > > > Kindly any body give solution to my problem. > > > > Sreedhar. > > ----- Original Message ----- > > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > > To: "shreedhar" <shreedhar@lucidindia.net> > > Sent: Thursday, December 26, 2002 11:03 PM > > Subject: Re: [ADMIN] Is there any eqvivalent or alternative to > > UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000 > > > > > > > > > > Your email is dated: > > > > > > Date: Fri, 15 Mar 2002 17:27:30 +0530 > > > > > > -------------------------------------------------------------------------- > > - > > > > > > shreedhar wrote: > > > > Is there any eqvivalent or alternative to the following IF > > UPDATE(column) or > > > > IF(COLUMNS_UPDATED()) of SQLServer2000. > > > > > > > > IF UPDATE (column) > > > > > > > > Tests for an INSERT or UPDATE action to a specified column and is not > > used > > > > with DELETE operations. More than one column can be specified. Because > > the > > > > table name is specified in the ON clause, do not include the table name > > > > before the column name in an IF UPDATE clause. To test for an INSERT or > > > > UPDATE action for more than one column, specify a separate > > UPDATE(column) > > > > clause following the first one. IF UPDATE will return the TRUE value in > > > > INSERT actions because the columns have either explicit values or > > implicit > > > > (NULL) values inserted. > > > > > > > > IF (COLUMNS_UPDATED()) > > > > > > > > Tests, in an INSERT or UPDATE trigger only, whether the mentioned column > > or > > > > columns were inserted or updated. COLUMNS_UPDATED returns a varbinary > > bit > > > > pattern that indicates which columns in the table were inserted or > > updated. > > > > > > > > Thanks And Regards, > > > > > > > > Sreedhar > > > > > > > > > > > > > > > > > > > > > > > > "Faith, faith, faith in ourselves, faith, faith in God, this is the > > secret > > > > of greatness. > > > > If you have faith in all the three hundred and thirty millions of your > > > > mythological gods, > > > > and in all the gods which foreigners have now and again introduced into > > your > > > > midst, > > > > and still have no faith in yourselves, there is no salvation for you. " > > > > (III. 190) > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > > > -- > > > Bruce Momjian | http://candle.pha.pa.us > > > pgman@candle.pha.pa.us | (610) 359-1001 > > > + If your life is a hard drive, | 13 Roberts Road > > > + Christ can be your backup. | Newtown Square, Pennsylvania > > 19073 > > > > > > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 >
Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000
From
Klaus Sonnenleiter
Date:
Sreedhar, From looking at the documentation at postgresql.org, it seems like this syntax is not supported. The compatibility description in the create trigger docs indicates that BEFORE UPDATE OF col_name is not supported either which probably means that Postgres has no knowledge of the statement that fired the trigger. Klaus On Friday 27 December 2002 12:53, shreedhar wrote: > Dear Momjian, > > I need solution for the problem stated in subject. (i.e.) any method to > know whether a record is Previously updated or not ? > > Sreedhar > ----- Original Message ----- > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > To: "shreedhar" <shreedhar@lucidindia.net> > Sent: Friday, December 27, 2002 10:41 AM > Subject: Re: [ADMIN] Is there any eqvivalent or alternative to > UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000 > > > Sure. As root, use the 'date' command to fix it. > > > > ------------------------------------------------------------------------- > >- > > - > > > shreedhar wrote: > > > Sorry, > > > > > > Because it is some problem in my system. So, it has shown Fri, 15 Mar > > 2002 > > > > 17:27:30 +0530. > > > > > > Kindly any body give solution to my problem. > > > > > > Sreedhar. > > > ----- Original Message ----- > > > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > > > To: "shreedhar" <shreedhar@lucidindia.net> > > > Sent: Thursday, December 26, 2002 11:03 PM > > > Subject: Re: [ADMIN] Is there any eqvivalent or alternative to > > > UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000 > > > > > > > Your email is dated: > > > > > > > > Date: Fri, 15 Mar 2002 17:27:30 +0530 > > > > ------------------------------------------------------------------------- > >- > > > > > - > > > > > > > shreedhar wrote: > > > > > Is there any eqvivalent or alternative to the following IF > > > > > > UPDATE(column) or > > > > > > > > IF(COLUMNS_UPDATED()) of SQLServer2000. > > > > > > > > > > IF UPDATE (column) > > > > > > > > > > Tests for an INSERT or UPDATE action to a specified column and is > > not > > > > used > > > > > > > > with DELETE operations. More than one column can be specified. > > Because > > > > the > > > > > > > > table name is specified in the ON clause, do not include the table > > name > > > > > > before the column name in an IF UPDATE clause. To test for an > > > > > INSERT > > or > > > > > > UPDATE action for more than one column, specify a separate > > > > > > UPDATE(column) > > > > > > > > clause following the first one. IF UPDATE will return the TRUE > > > > > value > > in > > > > > > INSERT actions because the columns have either explicit values or > > > > > > implicit > > > > > > > > (NULL) values inserted. > > > > > > > > > > IF (COLUMNS_UPDATED()) > > > > > > > > > > Tests, in an INSERT or UPDATE trigger only, whether the mentioned > > column > > > > or > > > > > > > > columns were inserted or updated. COLUMNS_UPDATED returns a > > varbinary > > > > bit > > > > > > > > pattern that indicates which columns in the table were inserted or > > > > > > updated. > > > > > > > > Thanks And Regards, > > > > > > > > > > Sreedhar > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > "Faith, faith, faith in ourselves, faith, faith in God, this is the > > > > > > secret > > > > > > > > of greatness. > > > > > If you have faith in all the three hundred and thirty millions of > > your > > > > > > mythological gods, > > > > > and in all the gods which foreigners have now and again introduced > > into > > > > your > > > > > > > > midst, > > > > > and still have no faith in yourselves, there is no salvation for > > you. " > > > > > > (III. 190) > > > > > > > > > > > > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > -- > > > > Bruce Momjian | http://candle.pha.pa.us > > > > pgman@candle.pha.pa.us | (610) 359-1001 > > > > + If your life is a hard drive, | 13 Roberts Road > > > > + Christ can be your backup. | Newtown Square, > > > > Pennsylvania > > > > > > 19073 > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup. | Newtown Square, Pennsylvania > > 19073 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly