From: | Paul Makepeace <postgresql(dot)org(at)paulm(dot)com> |
---|---|
To: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | UPDATE FROM syntax |
Date: | 2004-02-27 13:17:57 |
Message-ID: | 20040227131757.GM26803@mythix.realprogrammers.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
[this didn't apparently make it thru' to pgsql-docs]
Hi, is there any documentation for Pg's UPDATE FROM (apparently
non-standard) syntax? It is mentioned briefly in \h update and not at
all in http://www.postgresql.org/docs/7.3/static/dml-update.html
or http://www.postgresql.org/docs/7.3/static/queries-table-expressions.html
(directly).
I solved my own problem but was still curious since it's non-standard if
there's a "more standard" way of updating a table from another query.
ALTER TABLE components ADD COLUMN default_body TEXT;
UPDATE components SET default_body = bb.body
FROM (SELECT b.body, cpb.component_id
FROM componentspagesbodies cpb NATURAL JOIN bodies b
WHERE cpb.page_id IS NULL) AS bb
WHERE bb.component_id = components.component_id;
(Incidently, I tried UPDATE components c SET ... c.component_id but the
parser wasn't happy with it.)
Paul
(PS and now at least one working UPDATE FROM example is online ;-)
--
Paul Makepeace ................................ http://paulm.com/ecademy
"What is it i am yapping about? Three things: location, location,
location."
-- http://paulm.com/toys/surrealism/
From | Date | Subject | |
---|---|---|---|
Next Message | stm23 | 2004-02-28 01:14:56 | installing pgsql |
Previous Message | CoL | 2004-02-27 10:39:11 | Re: pg_dumpall and convert from LATIN1 to UTF-8? |