Re: Something I'd like to try...

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can someone comment on this?
>> 
>> I just noticed that postgres doesn't totally support
>> column aliases on UPDATE statements, for example

The SQL92 spec very clearly does not allow an alias on the target table:
        13.10  <update statement: searched>
        <update statement: searched> ::=             UPDATE <table name>               SET <set clause list>
  [ WHERE <search condition> ]
 

While I'm willing to consider variations from the spec that add
significant functionality, this proposed addition adds no functionality
worth noticing.  It'd just be another way to trip yourself up when
moving across DBMSes.
        regards, tom lane