I can't, it's an integer column ?!
-----Original Message----- From: Andreas Kraftl [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2008 11:47 AM To: [EMAIL PROTECTED] Subject: Re: [SQL] Is there a bug in PostgreSQL ? Am Donnerstag, den 11.12.2008, 11:33 +0200 schrieb Pascal Tufenkji: > dragon_test=# select distinct c.emp_id, c.institution, d.* from > sip_carriere c left join sip_demissionaire d on d.emp_id = c.emp_id > where c.emp_id = 2700 and d.emp_id is null; > > emp_id | institution | emp_id | demission_date > > --------+-------------+--------+---------------- > > (0 rows) What happens, if you try instead of "is null" a =""? select distinct c.emp_id, c.institution, d.* from sip_carriere c left join sip_demissionaire d on d.emp_id = c.emp_id where c.emp_id = 2700 and d.emp_id = ""; Greetings Andreas -- Kraftl EDV - Dienstleistungen Linux, Linuxschulungen, Webprogrammierung Autofabrikstraße 16/6 1230 Wien
