pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?
> > --






view thread (7+ messages)  latest in thread

Message-ID: <001e01c02ced$6a9a9200$02ffa8c0@terrificus>
Permalink:  ../001e01c02ced$6a9a9200$02ffa8c0@terrificus/
Also on:    postgresql.org/message-id/001e01c02ced$6a9a9200$02ffa8c0@terrificus

 · 

reply

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