Skip site navigation (1) Skip section navigation (2)

Re: Fw: Count rows group by time intervals

From: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>
To: "Oliveiros Cristina" <oliveiros(dot)cristina(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Fw: Count rows group by time intervals
Date: 2007-05-09 15:10:08
Message-ID: 1c23c8e70705090810k34dc7965w7bb935e6fa62f286@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
If I use
 SELECT date_part( date-'2007-01-01' )::int % 2
 FROM table
I get zeros and ones.

In response to

pgsql-novice by date

Next:From: Oliveiros CristinaDate: 2007-05-09 15:14:17
Subject: Re: Fw: Count rows group by time intervals
Previous:From: Loredana CurugiuDate: 2007-05-09 15:01:03
Subject: Re: Fw: Count rows group by time intervals

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group