| 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: | Whole Thread | Raw Message | 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/
| 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 . . . ] |