Scott Marlowe <scott.marlowe@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
