From: Richard Huxton <dev@archonet.com>
To: pgsql-sql@postgresql.org
Subject: UPDATE ... FROM vs standard SQL
Date: Fri, 7 Jun 2002 11:33:23 +0100
Message-ID: <200206071133.23179.dev@archonet.com> (raw)
I've been happily using statements like
UPDATE a SET flag=1 FROM b WHERE a.id=b.id AND b.foo='x';
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. The two options I can think of
are:
1. using a sub-select
UPDATE a SET flag=1 WHERE a.id IN (SELECT id FROM b WHERE b.foo='X');
Which is fine, but no good for mysql, hits PG's speed issue with IN and a bit
clumsy for more complicated examples.
2. building an updatable view.
Am I missing something here?
TIA
- Richard Huxton
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com
Subject: Re: UPDATE ... FROM vs standard SQL
In-Reply-To: <200206071133.23179.dev@archonet.com>
* 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