Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: pgsql-sql@postgresql.org
Subject: Re: UPDATE ... FROM vs standard SQL
Date: Fri, 7 Jun 2002 17:05:33 +0100
User-Agent: KMail/1.4.1
References: <web-1502464@davinci.ethosmedia.com>
In-Reply-To: <web-1502464@davinci.ethosmedia.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200206071705.33642.dev@archonet.com>

On Friday 07 Jun 2002 4:20 pm, Josh Berkus wrote:

> > While PG's FROM extension makes life simple, I can't believe there's
> > not a way
> > to do an update on a join using standard SQL.=20
>
> I don't understand why you're worried about this.  The lack of UPDATE
> .. FROM is widely regarded as an omission by the ANSI committee, and
> most SQL RDBMS support it, including MS SQL Server and Oracle.  I'm not
> sure about MySQL, but MySQL doesn't support sub-selects either.

Tell me about it. Where I'm using MySQL on client web-servers I find myself=
=20
porting the data into PG to massage it then putting the results back into=
=20
MySQL. One of the things missing from the various reviews/comparisons on th=
e=20
web is any actual comparison of usage for DBA tasks (as opposed to handling=
 a=20
message-board app etc)

> Is there a database you're tinking of that sticks to the strict SQL92
> definitions?  OpenBase, maybe?

Nope - mostly work with PG/MySQL/MS-SQL/Access. I use all the features at t=
he=20
psql prompt, but like to stick to the standard for app-generated queries.

Thanks Josh

- Richard Huxton