From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Sosteric <mikes@athabascau.ca>
Cc: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] arrays
Date: Mon, 30 Sep 2002 10:42:08 -0400
Message-ID: <21137.1033396928@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.SUN.3.96.1020930063733.13580B-100000@aupair.cs.athabascau.ca>
References: <Pine.SUN.3.96.1020930063733.13580B-100000@aupair.cs.athabascau.ca>
Mike Sosteric <mikes@athabascau.ca> writes:
> could you select where title[0] = 'en'
You certainly could ... but bear in mind that there's no convenient way
to make such a query be indexed, at present. So any values that you
actually want to use as search keys had better be in their own fields.
Now, if you are just using this as an extra search condition that picks
one row out of a small number that are identified by another WHERE
clause, then it's good enough to index for the other clause, and so the
lack of an index for title[0] isn't an issue. In this case, with only
a small number of possible values for title[0], it seems that an index
wouldn't be helpful anyway.
regards, tom lane
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: tgl@sss.pgh.pa.us, mikes@athabascau.ca, bruno@wolff.to, pgsql-general@postgresql.org
Subject: Re: [SQL] arrays
In-Reply-To: <21137.1033396928@sss.pgh.pa.us>
* 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