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