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

Can someone comment on this?

> 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
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026