Re: Can this query be optimized?

On Thu, Nov 08, 2001 at 01:19:25PM -0600, Claus Heiko Niesen wrote:
> At 10:49 AM 11/08/2001, Josh wrote:
>
> I just tried to build an index to see what the explain path would do but I
> get an error on the word extract:
>
> # create index week_pics_month_key on week_pics (extract(year from
> time_stamp), extract(month from time_stamp));
> ERROR: parser: parse error at or near "extract"

It's erroring on the second use of extract(). You can have multicolumn
indices, or you can have functional indices. You can't have a
multifunctional index (right now. I have'nt looked at the code to
see why.)

Ross