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/200910160726.n9g7qeeg097...@wwwmaster.postgresql.org This should be added to the FAQ... -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
