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

Reply via email to