I've only just now noticed that CREATE INDEX accepts a 'WHERE' clause.
This is used to create something called a "partial index". Hmm, ever
being one who sees the world as made of nails when first given a hammer ...
One of our tables, with a couple hundred thousand rows) has a
date-column inde
Jeff Boes <[EMAIL PROTECTED]> writes:
> If I created the index as something like:
> CREATE INDEX ix_foo ON foo(the_date)
> WHERE the_date >= now() - interval '24 hours';
> what might I expect as the impact?
You won't be allowed to, because now() isn't immutable, and only
immutable functi
In an attempt to throw the authorities off his trail, Jeff Boes <[EMAIL PROTECTED]>
transmitted:
> I've only just now noticed that CREATE INDEX accepts a 'WHERE'
> clause. This is used to create something called a "partial index".
> Hmm, ever being one who sees the world as made of nails when firs
ROTECTED] Behalf Of Jeff Boes
> Sent: 03 October 2003 17:35
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] Partial indexes ... any good theoretical discussion?
>
>
> I've only just now noticed that CREATE INDEX accepts a 'WHERE' clause.
> This is used to create somethi