| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hubert Palme <palme(at)uni-wuppertal(dot)de> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-sql(at)postgresql(dot)org, Hubert Palme <hubert(at)news(dot)tht(dot)net> |
| Subject: | Re: parse error in create index |
| Date: | 2001-02-12 15:54:04 |
| Message-ID: | 18588.981993244@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hubert Palme <palme(at)uni-wuppertal(dot)de> writes:
> adressen=> CREATE INDEX xxx ON geburtstage (geb_monat(geburtstag));
> ERROR: DefineIndex: (null) class not found
> adressen=>
Apparently you're using 6.5 or older ... I'd recommend updating!
IIRC, in <= 6.5 you *must* specify an operator class for a functional
index. So,
CREATE INDEX xxx ON geburtstage (geb_monat(geburtstag) float8_ops);
(assuming that geb_monat returns a float8, else adjust to suit).
Don't have a 6.5 server running anymore to check this on, however.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Ansley | 2001-02-12 15:57:03 | RE: plpgsql grief |
| Previous Message | Ross J. Reedstrom | 2001-02-12 15:53:46 | Re: view does not show all records it should |