Re: now() and interval

"Travis Hoyt" <thoyt(at)npc(dot)net> writes:
> Just curious, why does this date manipulation return the incorrect value
> based on the order of the operation?
> mydb=> select interval '1 month' + now();
> mydb=> select now() + interval '1 month';

Looking in pg_operator (or "\do +" in psql) shows that there is a
"timestamp plus interval" operator, but no "interval plus timestamp"
operator. So in the first case the system will pick one of the
available operators and then coerce your values to the appropriate
input datatypes. I'm too lazy to work out which pair of datatypes is
being selected, but a good bet is that the timestamp from now() is being
cut down to a date.

regards, tom lane