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.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