strange row count?

From: Radoslaw Stachowiak <radek(at)alter(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: strange row count?
Date: 2001-01-24 21:00:59
Message-ID: 20010124220059.Q26640@blue.alter.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

COuld someone explain me why a query:
mlotdev=> SELECT min(date_part('epoch',t_max-now())) FROM aibuf WHERE flag='A';
min
-----

(1 row)

showed one row (empty!!!!) while the query (equivalent one):
mlotdev=> SELECT date_part('epoch',t_max-now()) FROM aibuf WHERE flag='A' order by 1;
date_part
-----------
(0 rows)

showed 0 ?

This happens both in psql an libpq interface and is sth strage to me (but
maybe there is some point :)

The query/table details are non important ( You should get the same results on
other examples).

My postgresql is 7.0.3

--
radoslaw.stachowiak.........................................http://alter.pl/

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-01-24 21:07:51 Re: SQL Buffer question
Previous Message Frank Joerdens 2001-01-24 20:55:31 beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]