Re: missing FROM-clause entry

["Thomas H." <me(at)alternize(dot)com>]

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(at)nortel(dot)com>
To: <pgsql-general(at)postgresql(dot)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/