| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Alan Wayne <alanjwayne(at)yahoo(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
| Subject: | Re: Help Please on partial index |
| Date: | 2002-05-16 01:01:14 |
| Message-ID: | 20020516110114.B16632@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 15, 2002 at 03:17:49PM -0700, Alan Wayne wrote:
> Hi all!
>
> This is trully embarassing--why is my parser choking
> on this (am I missing a ' or something?):
>
> create unique index idx_zpeople_ichart on zpeople
> (ichart) where ichart > 0;
What version of postgres? Partial indexes wern't available till 7.2.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-05-16 01:05:56 | Re: C & C ++Program Problem |
| Previous Message | Martijn van Oosterhout | 2002-05-16 01:00:07 | Re: Force a merge join? |