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