Re: Postgres update with self join

From: "Igor Kryltsov" <kryltsov(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres update with self join
Date: 2004-08-12 00:16:16
Message-ID: cfecr8$11uq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you very much.

This works:
UPDATE

test

SET

code=T2.code

FROM

test T2

WHERE

test.code=0 AND

test.master=T2.name;

Igor

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Welty 2004-08-12 01:03:30 Re: PostgreSQL 8.0 Feature List?
Previous Message David Fetter 2004-08-11 23:54:53 Re: Coming soon: PG 7.4.4, 7.3.7, 7.2.5