Re: [GENERAL] what do i need to know about array index?

2010-07-21 Thread Prometheus Prometheus
> Date: Wed, 21 Jul 2010 12:38:55 +0800 > From: cr...@postnewspapers.com.au > To: prometheus...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] what do i need to know about array index? > > On 20/07/10 18:27, Prometheus Prometheus wrote: > >

[GENERAL] what do i need to know about array index?

2010-07-20 Thread Prometheus Prometheus
hi i have a table like this CREATE TABLE test( id bigint, tag boolean[] ) WITH ( OIDS=FALSE ); this is a parent table of some partition tables one table contains 1mio entries well in the future it should - currently only filled with test data the array is used to 'tag' a row which means eve