I have tried testing the perofmance on indexing array element using standard
btree and it doesn't help anything. It still costing alot.
create index idx_properties_address_4 on properties ((address_arr[4]))
does contrib/intarray effective for text array?
On 3/16/06, Oleg Bartunov wrote:
co
contrib/intarray might help you
Oleg
On Wed, 15 Mar 2006, [EMAIL PROTECTED] wrote:
On Wed, Mar 15, 2006 at 09:36:04AM -0700, Brendan Duddridge wrote:
Hi,
Is it possible to put an index on an array column?
Apparently yes (I just did it as a test). However, consider the
following from the ma
On Wed, Mar 15, 2006 at 09:36:04AM -0700, Brendan Duddridge wrote:
> Hi,
>
> Is it possible to put an index on an array column?
Apparently yes (I just did it as a test). However, consider the
following from the manual.
Tip: Arrays are not sets; searching for specific array elements
may b
Hi,Is it possible to put an index on an array column?Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.c
