Hi!

Is it possible to work with columns that accept arrays with SQLObject?  I'm
creating a structure that is similar to the examples on
http://www.postgresql.org/docs/8.0/interactive/arrays.html and I'd like to
have something that created the following SQL output (from the page above):

================================================================================
INSERT INTO sal_emp
    VALUES ('Bill',
    '{10000, 10000, 10000, 10000}',
    '{{"meeting", "lunch"}, {"training", "presentation"}}');
================================================================================

This will populate a table created with:

================================================================================
CREATE TABLE sal_emp (
    name            text,
    pay_by_quarter  integer[],
    schedule        text[][]
);
================================================================================

If it isn't possible, how would SQLObject behave if I declared columns as
string and replaced "[" and "]" by "{" and "}" from a stringified array?  My
main concern is with regards to retrieving data from the array since it looks
like this ugly insertion hack might work...

-- 
Jorge Godoy      <[EMAIL PROTECTED]>

"Quidquid latine dictum sit, altum sonatur."
- Qualquer coisa dita em latim soa profundo.
- Anything said in Latin sounds smart.



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to