Re: SQL timestamp to date cast

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Andrei Bintintan <klodoma(at)ar-sd(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL timestamp to date cast
Date: 2005-01-20 09:51:16
Message-ID: 20050120095116.GA37770@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jan 20, 2005 at 11:41:41AM +0200, Andrei Bintintan wrote:
> >Another possibility would be to create a functional index on datetime:
> >
> >CREATE INDEX user_action_date_idx ON user_action (date(datetime));
>
> GREAT!!! I thought it is possible but I didn't knew how to make such
> indexes. :))

See the "Indexes on Expressions" section in the "Indexes" chapter
of the documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-01-20 10:04:45 Re: Problem on Geometric functions
Previous Message Andrei Bintintan 2005-01-20 09:41:41 Re: SQL timestamp to date cast