John,

I was surprised discover that Rose::DB supports ARRAY data types,
natively in the Pg driver and via VARCHAR in other engines.
I have some questions about this.

Does the generic code store them in a string of the same forma the Pg
uses to set them, ie. '{1,"foo",-3,"bar bie",1.61818}' ?

What happens if someone manually shifted an element onto the front
of a Pg 1-D array, and the string was changed to '[-1:4]{.........}'
does your parser handle that?

What sort of querying can be done on ARRAY types?
cf. Pg's ANY() and ALL() functions.

Thanks for any help,

-- 
Torsten Seemann <[EMAIL PROTECTED]>
Victorian Bioinformatics Consortium



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to