getDate() and getTime() fails with columns of type 'TimeStamp'

In org.postgresql.jdbc2.ResultSet, both getDate() and getTime() fail on
columns of type 'timestamp', which is against the jdbc spec, patch below
fixes it.

Michael Stephenson mstephenson(at)openworld(dot)co(dot)uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738

--- ResultSet.java.old Wed May 30 16:32:48 2001
+++ ResultSet.java Wed May 30 16:41:33 2001
@@ -423,6 +423,8 @@
String s = getString(columnIndex);
if(s==null)
return null;
+ if (s.length() > 10)
+ return new java.sql.Date(getTimeStamp(columnIndex).getTime())

return java.sql.Date.valueOf(s);
}
@@ -441,6 +443,8 @@

if(s==null)
return null; // SQL NULL
+ if (s.length() > 8)
+ return new java.sql.Time(getTimeStamp(columnIndex).getTime());

return java.sql.Time.valueOf(s);
}