On Tue, Sep 26, 2006 at 11:17:00AM -0500, Glen W. Mabey wrote: > 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.
Okay, one more interesting piece of information: I get returned a list of lists when running 7.4, and I get a list of strings when running 8.1. Is 8.1 fully supported? Thanks, Glen _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
