[PyGreSQL] SELECTing arrays

[Glen W. Mabey]

On Mon, Sep 25, 2006 at 04:37:35PM -0500, Glen W. Mabey wrote:
> Hello,
> 
> I have used the ARRAY type in the design of my DB, or more precisely, 
> in the CREATE call, I use:
>     "fileNames"  VARCHAR(255)[]  UNIQUE NOT NULL
> 
> To my surprise, when fetching any combination of fields or rows from
> that table, all of the fields for each row are returned as a single
> string.  That is, a fetchall() operation returns a list of strings,
> instead of a list of lists as is returned on any other table I've tried
> it with.

Okay, I've learned a bit more about what I've observed; perhaps I posted
too hastily to this list.

It turns out that the difference between the structure of results that
I'm getting is that when I execute SELECTs in scripts that are run by
Apache, then the results are returned as a list of strings, but from the
command prompt, they are a list of lists.

I have uninstalled mod_python which (probably) was using a different
python for execution of such a script, but that didn't change anything.

Any ideas?

Thank you,
Glen Mabey