creating index using function
От
Matthew Engelbert
Тема
creating index using function
Дата
Msg-id
20041119202452.476.qmail@web60301.mail.yahoo.com
Список
Дерево обсуждения
creating index using function Matthew Engelbert <mje1975@yahoo.com>
Re: creating index using function Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
