Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6423A6338A3 for ; Wed, 8 Apr 2009 00:33:44 -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 08801-07 for ; Wed, 8 Apr 2009 00:33:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f222.google.com (mail-fx0-f222.google.com [209.85.220.222]) by mail.postgresql.org (Postfix) with ESMTP id 870946329BA for ; Wed, 8 Apr 2009 00:33:38 -0300 (ADT) Received: by fxm22 with SMTP id 22so4741570fxm.19 for ; Tue, 07 Apr 2009 20:33:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=BZWsxHYBy4joOTI+xHIZJ0Fi31W5OQyxziyNC6Uj3Gw=; b=M9uuRFKyy/1nMyQq2sJecpkJM3BE61quDRkka4wPQTuv5WEyh49Y48mbweC3PKscTt g8XbbMHkrbsspKuPxgZS9c0YotJOHActpUE6789Kpy87xcZmmMZl6a9mtTxGPx7wDOTZ 55+VHmv2RK7CKeMaavUpLBN5gZCXt+/Z2Dlc0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=qSFzuwIH/AQ0IPNxHqJg4/jlYVwdM4JY3EBhA5bO08Up3VqwOiDCuSiwETu6scNSka we0YBnv7ALuWo5Z63mJJTezR+D1JftLKbj3dMy/nMmlnxbTYf+j4EsEGKOTGpE+scwmg HZABkwgtzlFkbQMCmq0cgEiYVTiCABeBnoV+U= MIME-Version: 1.0 Received: by 10.103.172.9 with SMTP id z9mr303038muo.109.1239161617428; Tue, 07 Apr 2009 20:33:37 -0700 (PDT) In-Reply-To: References: <89DBB5874E89413698A8E275E5E79154@squarepi.com> <49DBA65B.9020706@esilo.com> <49DBAF74.5020409@kickstone.com> Date: Tue, 7 Apr 2009 23:33:37 -0400 Message-ID: Subject: Re: Array types From: Merlin Moncure To: James Pye Cc: John Lister , Andrew Chernow , pgsql-hackers@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.068 tagged_above=0 required=5 tests=AWL=0.068 X-Spam-Level: X-Archive-Number: 200904/415 X-Sequence-Number: 136518 On Tue, Apr 7, 2009 at 6:42 PM, James Pye wrote: > On Apr 7, 2009, at 12:54 PM, John Lister wrote: > >> Cheers, nice to know it is possible... Now to see if i can get java/python >> to do the same :) or to use a modified libpq somehow... > > http://python.projects.postgresql.org will do it for Python. =D > > tho, only supports Python 3, which is still quite new. I took a quick look at the pg python driver and was very impressed. They implemented a full top to bottom binary driver with type i/o functions in the vein of libpqtypes. If you are writing python, this is definitely the way to go. Kudos to them for seeing the light and doing it that way...it's much better coupling with the server than marshaling everything through text. merlin