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-31 19:52:02
Message-ID: auss27$2a8q$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yes, i know, I just write, that these are the possibilities. Or are
there any else?

C.

Klaus Sonnenleiter wrote, On 12/31/2002 3:25 PM:
> I think the question was how to find out which columns were affected by the
> update statement. TG_OP will only tell you whether an update fired the
> trigger.
>
> Klaus
>
> On Thursday 26 December 2002 03:29, CoL wrote:
>> 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
>>
>> ---------------------------(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Justin Georgeson 2002-12-31 20:57:30 Re: pg_hba
Previous Message Jie Liang 2002-12-31 19:35:16 Re: Stored procedures doubts