Re: plpython array support

Sean Davis wrote:
> On Nov 19, 2007 9:08 PM, Jorge Godoy <jgodoy(at)gmail(dot)com> wrote:
>> Em Monday 19 November 2007 19:29:51 Sean Davis escreveu:
>>> Just a simple question--does plpythonu (8.3beta) have support for
>>> arrays? I don't see a specific mention of it in the docs, so I
>>> suppose not.
>> Arrays work for a long time now. I've been using them since 8.1, for sure,
>> but I think that on 7.4 I already had code with arrays inside the database...
>
> Thanks, Jorge. I know that postgresql supports arrays, but I still
> don't see how plpython supports arrays. I noticed this post:
>
> http://archives.postgresql.org/pgsql-general/2007-01/msg01417.php
>
> from January, 2007 that suggests how to use the string representation
> of an array to convert to/from python arrays. This will work, but I
> was wondering if there is now a true conversion from postgresql arrays
> to python and vice-versa.

With 8.2, no there is not. Beyond the simple number and string times
everything gets cast to a string (arrays, tsvectors, etc.). I have no idea
if anyone is working on this for 8.3 or later.

--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/