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 m
"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
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 ou
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