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(dot)smart(at)ebeon(dot)com
> phone: (087) 8052390
>

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