Aha. Well, you learn something new every day. Yes, the behavior is indeed like "contact_id is not null", which was true for all rows in users, which explains why I lost all my data in realtycompany_contacts.

Thank goodness for backups. Many thanks!

James

On Jul 1, 2004, at 3:35 PM, Stephan Szabo wrote:

AFAIK the spec requires that subselects like that can reference outer
columns so contact_id inside the subselect refers to the outer contact_id
column which does exist (which makes the effective behavior of the above
clause the same as contact_id is not null I think)


----
James Robinson
Socialserve.com


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to