Anyone had any success entering an array from a checkbox form into PostgreSQL? My inability to figure out how to do this has upped the production of gray hairs on my noggin, and I'd fully appreciate any insight that you may have. I'm suspicious that PostgreSQL is incapable of handling arrays, but I'm not willing to give up just yet. Know anything about it?
Here's some sample code w/ results:
INSERT into table (pk, array)
VALUES ('$pk_id', '$array');
Warning: PostgreSQL query failed: ERROR: array_in: Need to specify dimension in file on line 2.
Thanks for whatever you know and share...
-Jay