the6campbells <the6campbells@gmail.com> writes:
> Why is Postgres returning a timestamp instead of the expected date data type
> for the first expression (the second returns a date)?
> select date '2001-03-30' - interval '1' year, date '2001-03-30' - integer
> '365' from tversion
Would you expect a date fordate '2001-03-30' - interval '1 hour'
? They are type-wise the same case; we don't have different types for
different lengths of interval.
regards, tom lane