Re: missing FROM-clause entry
От | Thomas H. |
---|---|
Тема | Re: missing FROM-clause entry |
Дата | |
Msg-id | 042001c6f6f4$3802ab70$0201a8c0@iwing обсуждение исходный текст |
Ответ на | missing FROM-clause entry ("Brandon Metcalf" <bmetcalf@nortel.com>) |
Ответы |
Re: missing FROM-clause entry
|
Список | pgsql-general |
you didn't reference the table "replica"... this should work: UPDATE model_timemap SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map) FROM replica WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189 ----- Original Message ----- From: "Brandon Metcalf" <bmetcalf@nortel.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, October 24, 2006 12:35 AM Subject: [GENERAL] missing FROM-clause entry > Just upgraded to 8.1.5 and the following UPDATE causes the "missing > FROM-clause entry" error: > > UPDATE model_timemap > SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN > replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map) > WHERE replica.replica_id = model_timemap.replica AND replica.proxy = > 32189 > > From what I've read, this typically results from referring to a table > instead of it's alias, but I don't see how that applies here. > > -- > Brandon > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ >
В списке pgsql-general по дате отправления: