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