Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Index on Date portion of timestamp - Mailing list pgsql-general

From Tom Lane
Subject Re: Create Index on Date portion of timestamp
Date
Msg-id 22130.1160771995@sss.pgh.pa.us
Whole thread Raw
In response to Create Index on Date portion of timestamp  ("Niederland" <niederland@gmail.com>)
List pgsql-general
Tree view 
"Niederland" <niederland@gmail.com> 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

pgsql-general by date:

Previous
From: "pobox@verysmall.org"
Date:
Subject: Re: encoding problem
Next
From: "A. Kretschmer"
Date:
Subject: Re: Create Index on Date portion of timestamp