From: Cristóvão Dalla Costa <cdallacosta@bigfoot.com>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Something I'd like to try...
Date: Tue, 3 Oct 2000 00:52:56 -0300
Message-ID: <001e01c02ced$6a9a9200$02ffa8c0@terrificus> (raw)
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?
> > --
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: cdallacosta@bigfoot.com
Subject: Re: Something I'd like to try...
In-Reply-To: <001e01c02ced$6a9a9200$02ffa8c0@terrificus>
References: <001e01c02ced$6a9a9200$02ffa8c0@terrificus>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox