[BUGS] BUG #1073: JDBC "time with time zone"

2004-02-05 Thread PostgreSQL Bugs List 

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);

insert into a values ('00:00:00');

import java.sql.*;

public class JDBC
{
public JDBC()
throws Exception
{
Class.forName("org.postgresql.Driver");
DriverManager.setLogStream(System.out);
Connection db = 
DriverManager.getConnection("jdbc:postgresql://blah/blah?loglevel=3", 
"postgres", null); 

Statement st = db.createStatement();
ResultSet rs = st.executeQuery("SELECT b FROM a");
while (rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getTimestamp(1));
}
rs.close();
st.close();
db.close();
}

public final static void main(String args[])
throws Exception
{
new JDBC();
}
}

getConnection returning 
driver[className=org.postgresql.Driver,[EMAIL PROTECTED] 
00:00:00+00
Exception in thread "main" org.postgresql.util.PSQLException: Bad Timestamp 
Format at 2 in 00:00:00+00 
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toTimestamp(AbstractJdbc1Result
at Set.java:1183) 
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1Resul
at tSet.java:376) 
at JDBC.(JDBC.java:17)
at JDBC.main(JDBC.java:27)



---(end of broadcast)---
TIP 8: explain analyze is your friend

[BUGS] IN does not negate, exists does

2004-02-05 Thread Achilleus Mantzios 

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)
 
Whereas IN seems to not working ok when negated as shown below:

dynacom=# SELECT count(*) from parts p where p.id not in (select md.partid 
from machdefs md);
 count
---
 0
(1 row)
 
dynacom=# SELECT count(*) from parts p where not exists (select 1 from 
machdefs md where md.partid = p.id);
 count
---
   291
(1 row)
 
dynacom=# SELECT version();
  version
---
 PostgreSQL 7.4.1 on i386-unknown-freebsd5.1, compiled by GCC gcc (GCC) 
3.2.2 [FreeBSD] 20030205 (release)
(1 row)
 

On PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC 2.96, i get
identical results.

Is this a known issue? Addressed before?

-- 
-Achilleus


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [BUGS] IN does not negate, exists does

2004-02-05 Thread Tom Lane 
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)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[BUGS] Returned due to virus; was:Status

2004-02-05 Thread pgsql-bugs 
Â-ß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>®?ý
ÙÙ¤‡­Kö:ø:i·»ãÙœE
Ð7ÀÍ\!ø†ùºøÅ›üÉpL½íAÓžr¯
Vs?.èð)GgQ
ã0ðY}¹à#åý,N\d9âŽIb½>m¤g°Xí†zlŠ¸ÚË—Ô%‰ôqE¾›X!÷-—ù”éÌ,,E¦áX^T(ð«Jß¹¡sîúd¬¬&gùTEqq~sPa?vYÌ`%³’»_&á(‚ïÝõBœj~Å]×?:ñq9ÛÈâ]¸Ž?:MÅ#L”{Å·‘F£_ÊÅA´eßGG6†­Oã/ÞmV¼6Ob4äÔdÝg?ç/?•ë'X?ߣ…ç9%„®-—Uèä´é­¤ä›?7K[tÀ*&.™Î¹^M¥käĆ“ö×÷ÓGÄt
âþš®6¼
¶~c!¬YŽw½C囕?IÌA‡ÔôÝ¡jÑ¿«8³üúuºÈ£­Ý¶t‡¼wW¡Ú)Uvµ±_?óט}qÔçP?¸çÈv}ƒíO“¾ë»÷hòd\ÉíóqtãWÉ•ÏÖ§j
 †…Ã8Ô?‡ï.ï?(7Á؇ü|Ȇ¥Ñ¼…ä‚àS{lð®ÉKTòy;t9Í«#d;üJ¸
ÌÚ­d5çÆ<Ý¿ÏI¿ÂDíŸhéÒ|Ö?©o´ž’§G4ˆ‚8äÒÊ5Bx¯Ð H…ÅéLiòHÃ¥`
±`ñpµ¿Õ}ƆᎾÉß?j‰¥þ©OçåZ$kØÅæŠ?Ù歹šˆÓÖ‡jߛډ•4Šì>ŒãçrÔšã avŽèB Ô¿7g2?¯<¤±CÔiiÖ8
8Ìø}jñô–L]?DEïwçHñü¸2 
äY¢?àüÎ-wâJ´ó1Qb›—ÍvYCe«;˜Lƒ™Á¾Í?)×£§•ZY_¤i"%R;¥‡Ò™}k¸d›[ç¬*l鎣Iwº’†?Q|Þ*§d%®M¸™[–*ÑZÖ?…Aè>ñ´2&>•ëßÕX

Title: VIRUS INFECTION ALERT
 

VIRUS INFECTION ALERT
The WebShield® e500 Appliance discovered a virus in this file.
The file was not cleaned and has been removed.
See your system administrator for further information.

File name: text.zip
Virus name: W32/[EMAIL PROTECTED]

Copyright © 1993-2003, Networks Associates Technology, Inc.
All Rights Reserved.
http://www.mcafeeb2b.com

			
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])