"Loredana Curugiu" <loredana.curugiu@gmail.com> writes:
>> On mine, If I subtract one date from the other I get the number of days
>> in between...which is another integer, I guess. and '%' is the modular
>> operator. Doesnt it work like this on yours?
> If I substract one date from the other I get an interval.
If you subtract two *date* values you get an integer. If you subtract
two *timestamp* values you get an interval.
regards, tom lane