On 12/1/05 7:17 PM, Torsten Seemann wrote: > 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}' ?
Yes, although that's technically a private implementation detail :) > 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? No, I've never even seen that syntax. Will the database itself actually return something like that? If so, can you give me an example that demonstrates it? > What sort of querying can be done on ARRAY types? > cf. Pg's ANY() and ALL() functions. None. Informix SET columns do have Manager support via the in_set, any_in_set, and all_in_set query operators: http://search.cpan.org/~jsiracusa/Rose-DB-Object/lib/Rose/DB/Object/QueryBui lder.pm I'm not too familiar with the similar functions in Pg. Can you post some example SQL that uses the Pg array operators in a WHERE clause? -John ------------------------------------------------------- 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