Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E487B6335FF for ; Wed, 8 Apr 2009 12:15:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83712-09 for ; Wed, 8 Apr 2009 12:15:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.kickstone.com (smtp.kickstone.com [87.194.183.70]) by mail.postgresql.org (Postfix) with ESMTP id A195C6333DB for ; Wed, 8 Apr 2009 12:15:42 -0300 (ADT) Received: from madras2.square-pi.com ([192.168.2.131]:1535 helo=MADRAS2) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1LrZV7-0005HV-0y; Wed, 08 Apr 2009 16:15:41 +0100 Message-ID: <93C5F665B92A4EB18E8480B34C001F04@squarepi.com> From: "John Lister" To: "Merlin Moncure" Cc: References: <89DBB5874E89413698A8E275E5E79154@squarepi.com> <4ECCF5BAADF94C5E9FD5CF2FA52CD061@squarepi.com> Subject: Re: Array types Date: Wed, 8 Apr 2009 16:15:40 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200904/441 X-Sequence-Number: 136544 No unfortunately not, it is a JDBC type 4 java which is entirely written in java. I've patched (as pointed out in another list) the base version to handle binary data (still a couple of issues that seem unfinished) which has given me clues, but the patch only supports simple types. I'm looking to create translator for arrays now.. I was hoping to use the java type handling for the internals of the array and throw an error on any "unknown" ones... I only use ints and floats in my arrays, so may leave it at that if it works and look at doing it properly later... > On Wed, Apr 8, 2009 at 10:48 AM, John Lister > wrote: >> Following this up, is there any docs on the binary wire format for >> arrays? >> >> Thanks >> > > Does java wrap libpq? If so, your best bet is probably going to be to > go the libpqtypes route. If you want help doing that, you are more > than welcome to ask (probably should move this thread to the > libqptypes list). If not, you are headed for a 'much bigger than it > looks on the surface' challenge...there are a lot of types...trust me > on this one. If you want help with libpqtypes you can ask on our list > on pgfoundry. > > merlin > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >