Functional indices with const params.

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Functional indices with const params.
Date: 2000-08-03 06:03:08
Message-ID: 00080313043603.22979@dyp.perchine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

is it possible to create functional indices with constant params?

I tried to do
create index ix_s_m on stats(date_part('month', sent_date));

And get
ERROR: parser: parse error at or near "'"

If it is not possible is there any workarounds for this?

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Perchine 2000-08-03 06:07:02 Using one of the indices to make query faster
Previous Message Guy Fraser 2000-08-03 03:44:49 Re: VS: Backup/dump of huge tables and performance