From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Jon Lapham <jlapham(at)gandalf(dot)bioqmed(dot)ufrj(dot)br> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Query-ing arrays |
Date: | 2000-09-01 16:07:35 |
Message-ID: | Pine.BSF.4.10.10009010906530.70404-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I'd suggest checking the array utilities in contrib. I believe
it has functions/operators for element in set.
Stephan Szabo
sszabo(at)bigpanda(dot)com
On Fri, 1 Sep 2000, Jon Lapham wrote:
> Stupid FAQ probably:
>
> Is it possible to query an array for an item WITHOUT KNOWING where in the
> array the item might be held?
>
> For example, I have a tbale with the following character array:
> > category char(3)[],
>
> I would like to find all records in which 'category' contains an array
> element of a certain type, like maybe 'xxx' for instance. So, for a
> particular record, 'category' may be set to '{'gfe','qwe','xcs','xxx'}'
>
> I cannot do:
> SELECT * FROM blah WHERE category[4]='xxx';
> because I do not know that the 'xxx' will always be in the 4th position.
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Lapham | 2000-09-01 18:31:38 | Re: Query-ing arrays |
Previous Message | Jon Lapham | 2000-09-01 15:27:04 | Query-ing arrays |