Re: indices and casts - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: indices and casts
Date
Msg-id 37d451f7041011154870ebdf34@mail.gmail.com
Whole thread Raw
In response to Re: indices and casts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
while you weren't looking, Tom Lane wrote:

> CREATE INDEX name ON table USING btree((column::date))

Nested parens.  D'oh.

It actually occurred to me to wonder if that might be the fix.  But I
thought, nah, too easy.

Thanks once again, Tom.

/rls

--
:wq

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: indices and casts
Next
From: Ramiro Batista da Luz
Date:
Subject: ...