Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Nico Grubert <nicogrubert(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
Date: 2009-03-06 16:04:33
Message-ID: 28960.1236355473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> The functionality is the same, since the now() will get rounded down
> to the date with time of 00:00:00. So, anytime for that day will be
>> = to the output of date_trunc('day',now())

Yeah. So actually it's sufficient to do
a.from_datetime >= current_date
and a regular index on from_datetime would be fine for that.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-03-06 16:06:41 Re: Installing a module for PostgreSQL
Previous Message Tom Lane 2009-03-06 16:02:07 Re: Performance of subselects