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

It seems to me that aliases on updates are something totally superflous.
Since updates always work on one table at a time, why bother especifying the
table each field comes from?

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