From: Evan Klinger <eklinger@uci.edu>
To: pgsql-sql@postgresql.org
Subject: PostgreSQL Array Syntax
Date: Mon, 05 Jan 2004 13:47:46 -0800
Message-ID: <3FF9DB82.8090202@uci.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eklinger@uci.edu
Subject: Re: PostgreSQL Array Syntax
In-Reply-To: <3FF9DB82.8090202@uci.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox