Обсуждение: plpython array support

Поиск
Список
Период
Сортировка

plpython array support

От
"Sean Davis"
Дата:
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.

Thanks,
Sean

Re: plpython array support

От
Jorge Godoy
Дата:
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...

--
Jorge Godoy      <jgodoy@gmail.com>


Re: plpython array support

От
"Sean Davis"
Дата:
On Nov 19, 2007 9:08 PM, Jorge Godoy <jgodoy@gmail.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.

Thanks,
Sean

Re: plpython array support

От
Stuart Bishop
Дата:
Sean Davis wrote:
> On Nov 19, 2007 9:08 PM, Jorge Godoy <jgodoy@gmail.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@stuartbishop.net>
http://www.stuartbishop.net/


Вложения