Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1CE0E6357AE for ; Wed, 8 Apr 2009 11:48:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 50934-01-4 for ; Wed, 8 Apr 2009 11:48:00 -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 53A086355D0 for ; Wed, 8 Apr 2009 11:48:07 -0300 (ADT) Received: from madras2.square-pi.com ([192.168.2.131]:4954 helo=MADRAS2) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1LrZ4O-0005DA-9J for pgsql-hackers@postgresql.org; Wed, 08 Apr 2009 15:48:04 +0100 Message-ID: <4ECCF5BAADF94C5E9FD5CF2FA52CD061@squarepi.com> From: "John Lister" To: References: <89DBB5874E89413698A8E275E5E79154@squarepi.com> Subject: Re: Array types Date: Wed, 8 Apr 2009 15:48:04 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0046_01C9B861.675FF450" 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.376 tagged_above=0 required=5 tests=AWL=0.375, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200904/434 X-Sequence-Number: 136537 This is a multi-part message in MIME format. ------=_NextPart_000_0046_01C9B861.675FF450 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Following this up, is there any docs on the binary wire format for = arrays? Thanks ----- Original Message -----=20 From: John Lister=20 To: pgsql-hackers@postgresql.org=20 Sent: Tuesday, April 07, 2009 7:54 PM Subject: [HACKERS] Array types Hi, using v8.3.5 and a number of client libraries (java, python, = pgadmin) and playing about with arrays. They all return arrays as text, is it possible to configure postgresql = to return an array in native form (does postgresql support such a = thing)? This is using both the simple and extended query forms - i = couldn't see a way to say what return type i wanted in the protocol = docs... This would seem much better in terms of performance, both size and = speed(conversion). Thanks -- Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/ ------=_NextPart_000_0046_01C9B861.675FF450 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Following this up, is there any docs on = the binary=20 wire format for arrays?
 
Thanks
----- Original Message -----
From:=20 John Lister
Sent: Tuesday, April 07, 2009 = 7:54=20 PM
Subject: [HACKERS] Array = types

Hi, using v8.3.5 and a number of = client libraries=20 (java, python, pgadmin) and playing about with arrays.
 
They all return arrays as text, is it = possible to=20 configure postgresql to return an array in native form (does = postgresql=20 support such a thing)? This is using both the simple and extended = query forms=20 - i couldn't see a way to say what return type i wanted in the = protocol=20 docs...
 
This would seem much better in terms = of=20 performance, both size and speed(conversion).
 
Thanks
 
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/<= BR>
------=_NextPart_000_0046_01C9B861.675FF450--