Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

[Alfred J F. <alf...@gm...>]

Should I assume that this is not possible?  Thank you for your time.

On 9/7/07, Alfred J Fazio <alf...@gm...> wrote:
>
> Many thanks, David.  If you find that you do not have the time to
> implement this, feel free to point me in the right direction and I'll pick
> up from there.  I wouldn't mind adding clauses for additional column types
> such as bit strings, etc.  Again, thank you so much!
>
> --
> Alfred J Fazio,
> alf...@gm...
>
> On 9/7/07, David Muse <dav...@fi...> wrote:
> >
> > This should be simple to fix.  I'm looking into it now and I'll let you
> > know what I find shortly.
> >
> > Dave
> > dav...@fi...
> >
> > On Wed, 2007-09-05 at 16:29 -0400, Alfred J Fazio wrote:
> > > Hi everyone,
> > >
> > >     I am using SQLRelay 0.38 via Python (2.4.4) to connect to a
> > > PostgreSQL (8.1.9) database.  I have noticed that if I create a table
> > > with an ARRAY column, that Sqlrelay returns the column type as
> > > UNKNOWN.  E.g., if I issue the following SQL:
> > >
> > > CREATE TABLE test (arr TEXT[][]);
> > >
> > > And fill it will some test data:
> > >
> > > INSERT INTO test (arr) VALUES (ARRAY[['fname', 'alfred'], ['lname',
> > > 'fazio'], ['age', '24'], ['employer', 'smoothstone']]);
> > >
> > > I will get an UNKNOWN value when calling getColumnType on the arr
> > > column above:
> > >
> > > >>> c.sendQuery("SELECT arr FROM test")
> > > >>> c.getField(0, 0)
> > > '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}'
> > > >>> c.getColumnType(0)
> > > 'UNKNOWN'
> > >
> > > It would be very convenient if I could test whether the column I am
> > > fetching is an ARRAY.  If so, I can automatically parse the result of
> > > the query into a native Python list.  I briefly peeked in the source
> > > code and saw that there has been a datatype declared for arrays for
> > > PostgreSQL in the src/common/datatypes.h file (called 'ANYARRAY').
> > > However, I didn't look around for long to see where I might implement
> > > the code needed to detect the column type.  Could somebody please
> > > point me to the right direction within the source code where I can
> > > perhaps add a clause for this situation?  I will then be happy to
> > > submit a patch to the list.
> > >
> > > Thanks for your time!
> > >
> > > --
> > > Alfred J Fazio,
> > > alf...@gm...
> > >
> > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc.
> > > Still grepping through log files to find problems?  Stop.
> > > Now Search log events and configuration files using AJAX and a
> > browser.
> > > Download your FREE copy of Splunk now >>   http://get.splunk.com/
> > > _______________________________________________ Sqlrelay-discussion
> > mailing list Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
> >
> > -------------------------------------------------------------------------
> >
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>   http://get.splunk.com/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
>
>


-- 
Alfred J Fazio,
alf...@gm...