Skip site navigation (1) Skip section navigation (2)

Re: numeric type

From: Peter Zeltins <peter(at)greatnowhere(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: numeric type
Date: 2008-07-29 21:23:33
Message-ID: 1217366613.5193.11.camel@peter-laptop (view raw or flat)
Thread:
Lists: pgsql-jdbc
> > OK, I hear ya. How about allowing user to set the default precision and
> > scale values for "numeric" type? Not sure how this would be done in JDBC
> > world but should be doable.
> 
> You could add URL parameters like unspecifiedNumericPrecision=1000 and 
> unspecificedNumericScale=500, but the tradeoff is how much work is it to 
> add these options to the URL parsing code and then pass them around, add 
> it to the datasource implementation, add it to the documentation, and ...
> 
> If there was some big important app that everyone wanted to use that blew 
> up on this I'd bet we'd do it, but I haven't heard a whole lot of 
> complaints about this problem.

I would assume this is not a major issue for most. Personally I ran into
this problem when writing automated PG->MS Access converter (Jackcess is
the only lib capable of creating MDB files on Linux/BSD) and it bailed
on numeric fields. 

Peter


In response to

Responses

pgsql-jdbc by date

Next:From: Daniel MigowskiDate: 2008-07-30 08:24:50
Subject: Re: numeric type
Previous:From: Kris JurkaDate: 2008-07-29 18:37:30
Subject: Re: GSSAPI/KRB5 and JDBC (again)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group