RE: [JDBC] BIGINT vs Java's long

2001-08-14 Thread Dave Cramer
This looks like a postgres problem, since I get the same problem in psql test=# update testbigint set fp0 = -9223372036854775808 where id = 1; ERROR: int8 value out of range: "-9223372036854775808" Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Be

Re: [JDBC] Which JDK to build jdbc1 driver on Linux?

2001-08-14 Thread Gunnar Rønning
* Rene Pijlman <[EMAIL PROTECTED]> wrote: | | What's the recommended JDK to build the jdbc1 version of the | driver on Linux? This is for test driving the driver. | | I guess it will have to be one from | http://www.blackdown.org/java-linux/ports.html, since AFAIK Sun | hasn't released Linux port

Re: [JDBC] tough one

2001-08-14 Thread John Anderson
At 16:51 2001/08/09 +0200, Tony Grant wrote: >festival| filmid >-- >1979| 102, 103, 104 >1980| 258, 369, 489, 568 > >How can I simulate an ARRAY of this type? If I can't - where is the >nearest bridge? you could define a tabl

[JDBC] How to read PG Circle and Point types from JDBC?

2001-08-14 Thread Bryan Field-Elliot
Would someone please (briefly) describe how I can read the Circle, or Point data types from PostgreSQL via JDBC? Thank you, Bryan ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/f

[JDBC] result sets from functions...

2001-08-14 Thread Robert J. Sanford, Jr.
i'm reading the postgres documentation and i'm specifically interested in creating stored procedures so that i can keep as much of the business logic in the database as possible. while reading 13.1.3 (SQL Functions on Composite Types) in the Programmer's Guide i come across the phrase... "When