[SQL] Something I'd like to try...

[Niall Smart]

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:  [EMAIL PROTECTED]
phone:  (087) 8052390