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);
So that indexes are used for queries when the field is cast to a date.
---(end of broadcast)---
TIP 4: Have you searched
On Thu, Oct 12, 2006 at 06:40:22PM -0700, Niederland wrote:
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);
So that indexes are used for queries when the field is cast to a date.
I didn't try it, but you ought
Niederland [EMAIL PROTECTED] 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
am Thu, dem 12.10.2006, um 18:40:22 -0700 mailte Niederland folgendes:
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);
CREATE INDEX i1 ON t1 USING BTREE (to_char(ts, 'dd-mm-' ));
*untested*
Please, let me
