parse error in create index - Mailing list pgsql-sql

From Hubert Palme
Subject parse error in create index
Date
Msg-id 3A7C6E10.FF4BCD8E@uni-wuppertal.de
Whole thread Raw
Responses Re: parse error in create index  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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@uni-wuppertal.de


pgsql-sql by date:

Previous
From: Ken Corey
Date:
Subject: Transactions in PLPGSQL?
Next
From: Andrew Perrin
Date:
Subject: "Subclassing" in SQL