Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: missing FROM-clause entry
- From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
- To: "Thomas H." <me(at)alternize(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: missing FROM-clause entry
- Date: Mon, 23 Oct 2006 17:43:37 -0500 (CDT)
- Message-id: <Pine(dot)LNX(dot)4(dot)58L(dot)0610231743150(dot)1695(at)cash(dot)us(dot)nortel(dot)com>
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
- References:
- missing FROM-clause entry
- From: Brandon Metcalf
- Re: missing FROM-clause entry
- From: Thomas H.
- missing FROM-clause entry
- Prev by Date: Re: missing FROM-clause entry
- Next by Date: Re: failing 8.1.4 autovacuum
- Previous by thread: Re: missing FROM-clause entry
- Next by thread: recovery from xid wraparound
- Indexes: