Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3AAE1632C6D for ; Tue, 7 Apr 2009 16:03:32 -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 03003-09 for ; Tue, 7 Apr 2009 16:03:24 -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 BDAE8636287 for ; Tue, 7 Apr 2009 15:54:21 -0300 (ADT) Received: from madras2.square-pi.com ([192.168.2.131]:2189 helo=MADRAS2) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1LrGR9-0002Zg-7K for pgsql-hackers@postgresql.org; Tue, 07 Apr 2009 19:54:19 +0100 Message-ID: <89DBB5874E89413698A8E275E5E79154@squarepi.com> From: "John Lister" To: Subject: Array types Date: Tue, 7 Apr 2009 19:54:19 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007A_01C9B7BA.A3843380" 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=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200904/373 X-Sequence-Number: 136476 This is a multi-part message in MIME format. ------=_NextPart_000_007A_01C9B7BA.A3843380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_007A_01C9B7BA.A3843380 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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 = support=20 such a thing)? This is using both the simple and extended query forms - = i=20 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 = performance, both size and speed(conversion).

Thanks

Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/<= BR>

------=_NextPart_000_007A_01C9B7BA.A3843380--