a "bug" in v6.4.3 ...

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: a "bug" in v6.4.3 ...
Date: 1999-03-06 20:28:28
Message-ID: Pine.BSF.4.05.9903061627350.7045-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Just trying to clean up alot of old code, and came across this:

acctng=> select max(start_time) from radhist where userid='billchuck';
max
---

(1 row)

acctng=> select * from radhist where userid='billchuck';
uniq_id|term_server|userid|ip_addr|port|start_time|stop_time|slipl
-------+-----------+------+-------+----+----------+---------+-----
(0 rows)

acctng=>

IMHO, the first select should return 0 rows, not 1, if no values are
found...no?

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Todd Graham Lewis 1999-03-06 21:27:15 RE: [HACKERS] RE: [GENERAL] Transaction logging
Previous Message Tom Lane 1999-03-06 17:20:49 Re: Number of parameters in a sql function