On Fri, Nov 12, 2010 at 10:43:14AM +0300, Dmitriy Igrishin wrote: > Hey Peter, > > Unfortunately, there is no indexes on arrays (only on expressions). > With hstore we can easily create GiST index for effective access. True. In my project I only ever needed to search on a particular key, and I made sure that that key always had a fixed position in the array. You can then create an index on the expression that extracts that index from the array. Cheers, Peter -- http://sjamaan.ath.cx -- "The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music." -- Donald Knuth -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
