Re: Create Index on Date portion of timestamp

[Tom Lane <tgl@xxxxxxxxxxxxx>]

"Niederland" <niederland@xxxxxxxxx> writes:
> I am using postgresql 8.1.4.
> Is there anyway to create an index equivalent to:
> CREATE INDEX i1 ON t1 USING btree  (ts::Date);

You're short some parentheses:

CREATE INDEX i1 ON t1 USING btree  ((ts::Date));

			regards, tom lane