Achilleus Mantzios <[EMAIL PROTECTED]> writes:
> Whereas IN seems to not working ok when negated as shown below:
If the sub-select returns any NULLs then this behavior is per SQL spec.
regards, tom lane
---(end of broadcast)
EXISTS and IN seem to work ok for:
dynacom=# SELECT count(*) from parts p where p.id in (select md.partid
from machdefs md);
count
---
12656
(1 row)
dynacom=# SELECT count(*) from parts p where exists (select 1 from
machdefs md where md.partid = p.id);
count
---
12656
(1 row)
Wh
Â-ß3ÑÙ‹¢)$TÝ—²K?Õ$O¿ÎO×»ïr9
xGlQñ“Ë„öÞNë}*£`߇ž‘ý($‰¤gnt˱šÊ̲¼ùÎ>¼§E™_˜ržw“‰ÖµÉÖ?«Óò¹Šâc]ýía·5zYá_:™8`Á"F,û1óŒ¼é[4½‚!}?6¼ì6‡¦ó¿’íw‘Á|3®BÓÄ;û–Ù#Ð_P–þôÄl0¯Æ(Uïò
5búg¶:ªŸ¹¤5|ð9-dB²0›?*—®z¤ßäµß’¢éHŽÛº4IJÈ?¢±Q¬¥õì Çä?‘ x†w{à~
.Ö¹ŽÔ)§cE»¬‘Ñ;é?²#\ì]£ØÆÜ<¾ÆïZÈú4‘WO²y»Û»-Q®$fôeržÁj*Þ‘—àŲzA5’ªßÔE>®?ý
ÙÙ¤‡
The following bug has been logged online:
Bug reference: 1073
Logged by: Bob Messenger
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.5 Dev
Operating system: Linux
Description:JDBC "time with time zone"
Details:
create table a(b time with time zone);
i
