searching in array

Peter Keller wrote:

Hi!
I'm using PostgreSQL 6.5b1 and I have two questions:
1. Is it possible to search for an element in an array even though I
don't know at which position the element is.

Sort of, but you need to load some extension operators available in the
contrib directory.

2. If this is possible how can I have a fast access. Can I create an
index, so that the search isn't sequential any more?

No, but since you could never have more than 2000 of them, it shouldn't
be too bad.

Thanks,
Peter
--
Peter Keller Tel: 089-2190-2594
Vermessungsrat z.A. Fax: 089-2190-2459
mailto:Peter.Keller@bvv.bayern.de
..............................................................
Bezirksfinanzdirektion M�nchen - Vermessungsabteilung
Alexandrastr. 3
80538 M�nchen
Zimmer: 404
www: http://www.bayern.de/vermessung/
--

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com