Received: from mail1.sirius.com (mail1.sirius.com [205.134.253.131])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA40236
	for <pgsql-hackers@postgresql.org>;
	Thu, 15 Jul 1999 13:41:36 -0400 (EDT)
	(envelope-from evan715@sirius.com)
Received: from sirius.com (ppp-asok05--033.sirius.net [205.134.245.33])
	by mail1.sirius.com (8.9.2/8.9.1) with ESMTP id KAA04313
	for <pgsql-hackers@postgresql.org>;
	Thu, 15 Jul 1999 10:39:57 -0700 (PDT)
Sender: root@mail1.sirius.com
Message-ID: <378E1B5C.BB792298@sirius.com>
Date: Thu, 15 Jul 1999 10:33:16 -0700
From: Evan Klinger <evan715@sirius.com>
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.10 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-hackers@postgresql.org
Subject: SELECT using arrays
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have asked this question on all of the appropriate pgsql mailing lists
and no one has been able to help. Please, if you could, help me out with
this problem. Thank you.
--

I have been playing around with this for some time now to no avail. I
have a table info with a two-dimensional text type array action. Is
there any way to select the corresponding value of one of the elements
without knowing the order of the elements?

E.g.

CREATE TABLE info (action text[][]);

INSERT INTO info VALUES ('{{"VAR","VAL"},{"VAR2","VAL2"}}');

Now what SELECT query will search for "VAR" within text[][] (in this
case it is the first element, but it may not always be) and print out
"VAL."


Any information would be greatly appreciated.

Thank you very much.

Evan