| 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: | Whole Thread | Raw Message | 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 - |