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/

Reply via email to