Home > mailing lists

creating index using function - Mailing list pgsql-novice

From	Matthew Engelbert
Subject	creating index using function
Date	November 20, 2004 01:13:40
Msg-id	20041119202452.476.qmail@web60301.mail.yahoo.com Whole thread Raw
Responses	Re: creating index using function (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

Tree view

I would like to create an index on table ecn_sales, based on the day of year
value of a timestamp column tv_time.   However, I'm getting an error:

CREATE INDEX ecn_sales_index_day on ecn_sales (extract(DOY FROM tv_time));
ERROR:  syntax error at or near "(" at character 55

Any help would be appreciated.  Thanks.

- Matt

pgsql-novice by date:

From: sarlav kumar
Date: 19 November 2004, 21:39:18
Subject: another index scan problem

From: Tom Lane
Date: 20 November 2004, 04:19:29
Subject: Re: creating index using function

creating index using function - Mailing list pgsql-novice

Previous

Next