> 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:
>
>
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