Something I'd like to try... - Mailing list pgsql-sql

Hi,

I just noticed that postgres doesn't totally support
column aliases on UPDATE statements, for example        UPDATE EMPLOYEES SET                OFFICE_PHONE =
UU.OFFICE_PHONE,               MOBILE_PHONE = UU.MOBILE_PHONE,                OFFICE_CD = UU.OFFICE_CD,
ABOUT_ME= UU.ABOUT_ME        FROM                UNCONFIRMED_UPDATES UU        WHERE
EMPLOYEES.EMPLOYEE_ID= UU.EMPLOYEE_ID AND                UU.UPDATE_ID = 'HJhjaJ023J19KJAqp'
 

It is not currently possible to alias EMPLOYEES
so that the test can become
        E.EMPLOYEE_ID = UU.EMPLOYEE_ID

Do the guru's think that this would be hard to add?  Also,
is it desirable?
--

Niall Smart

email:  niall.smart@ebeon.com
phone:  (087) 8052390