a "bug" in v6.4.3 ... - Mailing list pgsql-hackers

From The Hermit Hacker
Subject a "bug" in v6.4.3 ...
Date
Msg-id Pine.BSF.4.05.9903061627350.7045-100000@thelab.hub.org
Whole thread Raw
List 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@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Number of parameters in a sql function
Next
From: Todd Graham Lewis
Date:
Subject: RE: [HACKERS] RE: [GENERAL] Transaction logging