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
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 - |