On 11/02/2011 03:16 AM, Valentine Gogichashvili wrote:
Putting aside arguments like "it is not a good idea to use * because
it generates not sustainable code especially in case when you extend
table structure", I think this construct would be really nice for
building ROWs, for example in plpgsql triggers or in conditions for
big update statements:
IF (NEW.* EXCLUDING ( last_modified ) ) IS DISTINCT FROM (OLD.*
EXCLUDING ( last_modified ) ) THEN NEW.last_modified =
clock_timestamp() ; END IF
That's a very good use case. I could certainly have used this in the past.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers