The following bug has been logged online:

Bug reference: 1402
Logged by: raxfar
Email address: raxfar (AT) yahoo (DOT) com.tw
PostgreSQL version: 8.0.0-rc2
Operating system: windows 2000
Description: getPrecision don't work
Details:

have
java.sql.ResultSetMetaData _oMetaData.getPrecision(i)
java.sql.ResultSetMetaData _oMetaData.getScale(i)
methods not to get Precision and Scale

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Sat, 15 Jan 2005, raxfar wrote:
What underlying data type are you trying to call these methods on? You
need to provide some more information to describe what you are doing.

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

raxfar wrote:
What JDBC driver version are you using?

What is the type of the columns that you are calling getPrecision() and
getScale() on? Do you have an example schema and query I can try out?

What are the results you get? What are the results you expected to get?

-O

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Tue, 18 Jan 2005, Woung raxfar wrote:

I don't believe getPrecision is intended to operate on non-numeric fields.
Perhaps you are looking for getColumnDisplaySize() ?

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings