This might have been discussed before but I wanted to know if clustering tables
by partial indexes will be availble in a later release of pgSQL?
For the record, this is the error I get in 8.1:
iprism=# cluster hrs_idx on report;
ERROR: cannot cluster on partial index "hrs_idx"
hrs_idx is defined as:
iprism=# \d hrs_idx
Index "public.hrs_idx"
Column | Type
--------+--------------------------
stamp | timestamp with time zone
btree, for table "public.report", predicate (thehour(stamp) >= 0::double
precision AND thehour(stamp) <= 23::double precision)
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com