From: | "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb> |
---|---|
To: | "'Andreas Kraftl'" <andreas(dot)kraftl(at)kraftl(dot)at> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Is there a bug in PostgreSQL ? |
Date: | 2008-12-11 09:57:36 |
Message-ID: | 003c01c95b76$e55f0cd0$150fa8c0@interne.usj.edu.lb |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-12-11 14:40:07 | Re: Is there a bug in PostgreSQL ? |
Previous Message | Pascal Tufenkji | 2008-12-11 09:33:30 | Re: Is there a bug in PostgreSQL ? |