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

Re: Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED()

From: CoL <col(at)mportal(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED()
Date: 2002-12-26 20:29:48
Message-ID: aufodo$2a2g$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
http://www.postgresql.org/idocs/index.php?trigger-manager.html
http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html
TG_OP ?

C.

shreedhar wrote, On 12/26/2002 12:57 PM:
> 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


In response to

Responses

pgsql-admin by date

Next:From: shreedharDate: 2002-12-27 03:58:35
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000
Previous:From: Tom LaneDate: 2002-12-26 18:07:16
Subject: Re: [BUGS] pgdb.py is still wrong [not just] in Postgres 7.3.1 rpm

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