| From: | Evan Klinger <eklinger(at)uci(dot)edu> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | PostgreSQL Array Syntax |
| Date: | 2004-01-05 21:47:46 |
| Message-ID: | 3FF9DB82.8090202@uci.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Good afternoon.
I am attempting to create a PHP script that inserts values into a
PostgreSQL database, where some of the columns are two dimensional
arrays. I read the docs and it says that array elements must be matched
and that is what I am confused about. Does that mean that
ARRAY[['eng_labs'], ['eng_labs', 'mst_labs', 'ics_labs']] is incorrect
array syntax? If so, I am assuming that the way to correct it would be:
ARRAY[['eng_labs', '', ''], ['eng_labs', 'mst_labs', 'ics_labs']]. Thus,
each multidimensional array must have values in place for the largest
element, correct?
Thank you for your time
Evan Klinger
--
Evan Klinger
Network & Academic Computing Services
Research Computing Support
University of California, Irvine
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Hall | 2004-01-05 23:21:59 | Re: Virtual records |
| Previous Message | Paul Tilles | 2004-01-05 18:14:37 | ecpg - problem compiling prepare and declare statements |