date_part, too many results?

From: M(dot)Mazurek(at)poznan(dot)multinet(dot)pl
To: pgsql-sql(at)postgresql(dot)org
Subject: date_part, too many results?
Date: 2000-02-24 22:38:48
Message-ID: Pine.BSF.4.21.0002242237050.31209-100000@arka.poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
clicked table is empty for bannerid=1, so why is that row? How to get rid
of it?
tia
mazek

bannerdb=> select count(*),date_part('dow',data::datetime) from clicked
where bannerid=1 group by date_part('dow',data::datetime);
count|date_part
-----+---------
0|
(1 row)

Marcin Mazurek

--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Kane 2000-02-24 23:54:18 arrays of varchar and "
Previous Message Alex Howansky 2000-02-24 22:27:21 how to create index on timestamp field in pre v7 database