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