Re: [SQL] [JDBC] contrib/ltree

2003-09-10 Thread Barry Lind
I would recommend using getString()/setString(). You will need to marshall the data into the correct format, but you will at least be able to get and set the values. --Barry [EMAIL PROTECTED] wrote: how do i get jdbc to recognize the ltree type that comes with the contrib/ltree extension? This

Re: [SQL] [JDBC] column doesn't get calculated - update # 2

2003-07-19 Thread Barry Lind
Floyd, I would recommend turning sql statement tracing on in the database to see the exact sql text that the driver is sending to the database (in case it is somehow munging it). Then take that exact same text (as found in the server log files) and run it in psql to see how it works there. --

Re: [SQL] jdbc driver

2001-10-02 Thread Barry Lind
Esteban, Try http://jdbc.postgresql.org thanks, --Barry PS. There is a pgsql-jdbc mail list which would be a more appropriate place for this question. Esteban Gutierrez Abarzua wrote: > hi. > > who to knows about the java + postgresql (jdbc)? > > I need to know where can I get the

Re: [SQL] Something I'd like to try...

2000-10-03 Thread Barry Lind
It is interesting that this should come up now. Just last week I was trying to port a SQL statement from Oracle to Postgresql that used table aliases in an update statement. While I can see that this functionality wouldn't be used very often it can be very useful under certain circumstances. I