Re: Is there a bug in PostgreSQL ? - Mailing list pgsql-sql
| From | Pascal Tufenkji |
|---|---|
| Subject | Re: Is there a bug in PostgreSQL ? |
| Date | |
| Msg-id | 003c01c95b76$e55f0cd0$150fa8c0@interne.usj.edu.lb Whole thread Raw |
| In response to | Is there a bug in PostgreSQL ? ("Pascal Tufenkji" <ptufenkji@usj.edu.lb>) |
| List | pgsql-sql |
<div class="Section1"><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">I can't, it'san integer column ?!</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt"> </span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">-----OriginalMessage-----<br /> From: Andreas Kraftl [mailto:andreas.kraftl@kraftl.at] <br /> Sent:Thursday, December 11, 2008 11:47 AM<br /> To: ptufenkji@usj.edu.lb<br /> Subject: Re: [SQL] Is there a bug in PostgreSQL?</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt"> </span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">AmDonnerstag, den 11.12.2008, 11:33 +0200 schrieb Pascal Tufenkji:</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt"> </span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">> dragon_test=# select distinct c.emp_id,c.institution, d.* from</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">>sip_carriere c left join sip_demissionaire d on d.emp_id = c.emp_id</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">> where c.emp_id = 2700 and d.emp_idis null;</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">> </span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">> emp_id | institution| emp_id | demission_date</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">></span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">>--------+-------------+--------+----------------</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">> </span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">> (0 rows)</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt"> </span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">What happens, if you try instead of "isnull" a =""?</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">selectdistinct c.emp_id, c.institution, d.* from sip_carriere c left</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">join sip_demissionaire d on d.emp_id = c.emp_idwhere c.emp_id = 2700</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">andd.emp_id = "";</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt"> </span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">Greetings</span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">Andreas</span></font><pclass="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">--</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><span style="font-size:10.0pt">KraftlEDV - Dienstleistungen</span></font><p class="MsoPlainText"><font face="Verdana" size="2"><spanstyle="font-size:10.0pt">Linux, Linuxschulungen, Webprogrammierung</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">Autofabrikstraße 16/6</span></font><p class="MsoPlainText"><fontface="Verdana" size="2"><span style="font-size:10.0pt">1230 Wien</span></font></div>