Skip site navigation (1) Skip section navigation (2)

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

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>,"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000
Date: 2002-12-27 05:53:38
Message-ID: 000501c2ad6c$4d53b580$1201a8c0@a4005 (view raw or flat)
Thread:
Lists: pgsql-admin
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
>


Responses

pgsql-admin by date

Next:From: Klaus SonnenleiterDate: 2002-12-27 09:26:41
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000
Previous:From: shreedharDate: 2002-12-27 03:58:35
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group