X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 80DC8D1B468 for ; Mon, 5 Jan 2004 21:44:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 73714-05 for ; Mon, 5 Jan 2004 17:43:33 -0400 (AST) Received: from smtp2.es.uci.edu (smtp2.es.uci.edu [128.200.80.5]) by svr1.postgresql.org (Postfix) with ESMTP id 3C8E0D1B437 for ; Mon, 5 Jan 2004 17:43:32 -0400 (AST) Received: from uci.edu (rcs64.nac.uci.edu [128.200.16.103]) by smtp2.es.uci.edu (8.12.8/8.12.8) with ESMTP id i05LhLjZ007735 for ; Mon, 5 Jan 2004 13:43:21 -0800 Message-ID: <3FF9DB82.8090202@uci.edu> Date: Mon, 05 Jan 2004 13:47:46 -0800 From: Evan Klinger User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.4) Gecko/20030819 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: PostgreSQL Array Syntax Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-UCIRVINE-MailScanner: No viruses found X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/58 X-Sequence-Number: 16451 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