Vadim Grepan ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
cannot create functional index
Long Description
I've tried to create functional index like
that:
=== cut ===
db=> CREATE INDEX NDX_FNC_TBL_TRAFBYTES__DATE ON tbl_trafbytes (date (date_trunc
('day', trafbytes_date)));
ERROR: parser: parse error at or near "("
=== cut ===
Column trafbytes_date define as
=== cut ===
trafbytes_date | timestamp without time zone | not null
=== cut ===
Does it means that PostgreSQL funcional indexes support only simplest fucntions like
lower ()?
Sample Code
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
