Re: Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000 - Mailing list pgsql-admin

From shreedhar
Subject Re: Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000
Date
Msg-id 000d01c2ad5c$3b1036b0$1201a8c0@a4005
Whole thread Raw
List pgsql-admin
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
>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] pgdb.py is still wrong [not just] in Postgres 7.3.1 rpm
Next
From: "shreedhar"
Date:
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000