Fred Wei wrote: > cod_old=# delete from tmp where k in (select k from tmp2); > DELETE 1 > --this is wrong, because k does not exist in tmp2!
That behavior is correct, k is referring to tmp.k. See http://archives.postgresql.org/message-id/[email protected] This should be added to the FAQ... -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
