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

[SQL] Re: RE: Create table in functions

2000-09-01 Thread Andreas Tille
On Thu, 31 Aug 2000, Jan Wieck wrote: First of all thank you very much for your effort! This is definitely a good argument for PostgeSQL to have such fast support in adding features which might convince some of my collegues or my boss :). > Could you try out the current CVS sources? Well, I