Re: [GENERAL] 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(dot)Keller(at)bvv(dot)bayern(dot)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(dot)bitmead(at)bigfoot(dot)com