parse error in create index

From: Hubert Palme <palme(at)uni-wuppertal(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: parse error in create index
Date: 2001-02-03 20:46:08
Message-ID: 3A7C6E10.FF4BCD8E@uni-wuppertal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

could someone, please, explain me the following parse error?

adressen=> \d geburtstage
Table = geburtstage
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| lfd_nr | int4
| 4 |
| geburtstag | date
| 4 |
+----------------------------------+----------------------------------+-------+
adressen=> create index Monat_Tag on geburtstage (date_part('month',
Geburtstag));
ERROR: parser: parse error at or near "'"
adressen=>

Thanks in advance,

--
Hubert Palme
palme(at)uni-wuppertal(dot)de

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-03 22:15:51 Re: PL/pgSQL: possible parsing or documentation bug?
Previous Message Peter Eisentraut 2001-02-03 19:18:55 Re: Suggestion for psql: --file -