Is it possible to create an index on the elements of an array, or a
functional index on a set-returning function?
The index only needs to speed up queries for specific elements (using
a simple member****p test, position in the array does not matter) and
perhaps range queries. The indexed types include integers and text
strings, and possibly more (IP addresses, for instance). The number
of elements per indexed array rarely exceeds 4, I think.
I fear that the distribution of values makes the intarray module and
full text search inappropriate choices (lots of values unique to a
specific row).
--=20
Florian Weimer <fweimer@[EMAIL PROTECTED]
>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstra=DFe 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
