Re: missing FROM-clause entry

From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
To: "Thomas H(dot)" <me(at)alternize(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: missing FROM-clause entry
Date: 2006-10-23 22:43:37
Message-ID: Pine.LNX.4.58L.0610231743150.1695@cash.us.nortel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

m == me(at)alternize(dot)com writes:

m> you didn't reference the table "replica"... this should work:
m> UPDATE model_timemap
m> SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
m> 32191 THEN 5739 ELSE -1 END, 1161642129, map)

m> FROM replica

m> WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189

Ah. Thanks.

--
Brandon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-23 22:58:15 Re: failing 8.1.4 autovacuum
Previous Message Thomas H. 2006-10-23 22:40:18 Re: missing FROM-clause entry