Re: missing FROM-clause entry
От
Brandon Metcalf
Тема
Re: missing FROM-clause entry
Дата
Msg-id
Pine.LNX.4.58L.0610231743150.1695@cash.us.nortel.com
Ответ на
Re: missing FROM-clause entry (Thomas H.)
Список
Дерево обсуждения
missing FROM-clause entry "Brandon Metcalf" <bmetcalf@nortel.com>
m == me@alternize.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
В списке pgsql-general по дате отправления