Re: Array support

From: Thomas O'Dowd <tom(at)uwillsee(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Array support
Date: 2005-04-28 15:17:09
Message-ID: 1114701429.8404.94.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris,

> Right, the ARRAY[] syntax is part of the parser which doesn't get invoked
> on parameters, so you need to use the {} format.

Gotcha.

> > Q: How do I set an array column to null using a PreparedStatement?
>
> This is indeed a bug, I've fixed this in the 8.0 + head branches. Updated
> jar files are available here:
>
> http://www.ejurka.com/pgsql/jars/tod/

Just downloaded the new driver and tested it. It works a charm. Thanks
for tracking this down so promptly and making the jar available.

Best regards,

Tom.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-04-28 15:22:01 Re: Statement Timeout and Locking
Previous Message Kris Jurka 2005-04-28 14:58:13 Re: _pg_keyposition is gone in HEAD