IN selection issues
От
Jérôme Calais
Тема
IN selection issues
Дата
Msg-id
1043230236.1116.15.camel@Neptune
Список
Дерево обсуждения
IN selection issues Jérôme Calais <jerome.calais@arunix.fr>
Re: IN selection issues Tom Lane <tgl@sss.pgh.pa.us>
Re: IN selection issues Peter Eisentraut <peter_e@gmx.net>
I am encountering problems with IN selections. I am trying this query : delete from status where status_id not in (select distinct status_id from company); "status_id" is a foreign key in "company". It does not delete any records from status table whereas it should because the sub query returns some records. Any explanation ? Thanks -- M. Jérôme CALAIS (Ingénieur Conseil) Portable: 0620648297 E-Mail: jerome.calais@arunix.fr ------------------------------ Arunix Z.A.L St Amé 62806 Liévin Cedex France Tel: 0321142843 Fax: 0321142831 URL: http://www.arunix.fr
В списке pgsql-bugs по дате отправления
От: Andreas Lange
Дата:
