Re: Is there a bug in PostgreSQL ?

I can't, it's an integer column ?!

-----Original Message-----
From: Andreas Kraftl [mailto:andreas(dot)kraftl(at)kraftl(dot)at]
Sent: Thursday, December 11, 2008 11:47 AM
To: ptufenkji(at)usj(dot)edu(dot)lb
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