Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000

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(at)candle(dot)pha(dot)pa(dot)us>
> To: "shreedhar" <shreedhar(at)lucidindia(dot)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(at)candle(dot)pha(dot)pa(dot)us>
> > > To: "shreedhar" <shreedhar(at)lucidindia(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly