Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MGiZx64799 for ; Thu, 22 Feb 2001 11:44:35 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f1MGiXF64794; Thu, 22 Feb 2001 11:44:33 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: Mike Friesen Subject: Re: JDBC Array Support? Message-ID: <982860273.3a9541f151e3b@webmail.retep.org.uk> Date: Thu, 22 Feb 2001 11:44:33 -0500 (EST) From: Peter T Mount Cc: pgsql-interfaces@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200102/158 X-Sequence-Number: 1115 Quoting Mike Friesen : > > I was wondering if anyone can tell me whether the postgresql JDBC > driver > support array datatype? From my experimenting the answer is "no". Is > there any type of work around? No, not yet. The JDBC2.1 extensions of an Array type actually refer to a different type of arrays, so the only way is to implement some new extension for them. Due to time constraints, I wasn't going to look at them until after 7.1 is out (I'm concentrating on documentation now). Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/