Re: Fw: Count rows group by time intervals - Mailing list pgsql-novice

From Tom Lane
Subject Re: Fw: Count rows group by time intervals
Date
Msg-id 27240.1178724498@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fw: Count rows group by time intervals  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: Fw: Count rows group by time intervals
Next
From: Jim Nasby
Date:
Subject: Re: how to view the content of schema pg_catalog?