I have a view view1 with a column foo, among others.

A rule intercepts an update on view1. Is there a way for the rule to
distinguish between

* foo is in the SET clause and is set to NULL
* foo is not in the SET clause

?

Thanks
--
KM

KM wrote:
The NEW.* values for columns which are *not* in the set clause
are not NULL, they retain the original values.

There is no way in the rule to tell whether a certain column
was in the SET clause or not, but that has nothing to do with
NULL values.

So: technically the answer to your question is "no", but it
seems like you asked the question based on wrong information.

Yours,
Laurenz Albe

Il 23/03/2010 4.53, KM ha scritto:

Perhaps with upcoming 8.5 version you'll can use a trigger for the same
purpose on the underlying table, but you have to wait some months:

http://developer.postgresql.org/pgdo...lease-8.5.html
"Add SQL-compliant triggers on columns, which fire only if certain
columns are named in the UPDATE's SET list."