Re: [SQL] Query-ing arrays

2000-09-01 Thread Jon Lapham
On Fri, Sep 01, 2000 at 09:07:35AM -0700, Stephan Szabo wrote: > > I'd suggest checking the array utilities in contrib. I believe > it has functions/operators for element in set. Thanks, that looks like exactly what I need. I wonder if someone could put a reference to this array utility packag

Re: [SQL] Query-ing arrays

2000-09-01 Thread Stephan Szabo
I'd suggest checking the array utilities in contrib. I believe it has functions/operators for element in set. Stephan Szabo [EMAIL PROTECTED] 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

[SQL] Query-ing arrays

2000-09-01 Thread Jon Lapham
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