Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

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