From: Evan Klinger <evan715@sirius.com>
To: pgsql-hackers@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: SELECT using arrays
Date: Wed, 14 Jul 1999 14:05:00 -0700
Message-ID: <378CFB7C.6BE05DA0@sirius.com> (raw)
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 action (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
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-hackers@postgresql.org
Cc: evan715@sirius.com, pgsql-sql@postgresql.org
Subject: Re: SELECT using arrays
In-Reply-To: <378CFB7C.6BE05DA0@sirius.com>
* 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