From: | Jochen Scharrlach <js(at)mgm-net(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | GROUP BY and empty queries |
Date: | 1999-06-21 10:51:46 |
Message-ID: | 376E1941.CA6E3774@mgm-net.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
sorry if this is a FAQ, but I have a bit trouble with PostgreSQL 6.5 on
a RedHat 5.2 machine:
----snip----
js=> create table testi (number int, name varchar(40));
CREATE
js=> insert into testi values (1, 'myname');
INSERT 151274 1
js=> select sum(number) from testi where name='myname';
sum
---
1
(1 row)
js=> select * from testi where name='notthere';
number|name
------+----
(0 rows)
js=> select sum(number) , name from testi where name='notthere' group by
name;
sum|name
---+----
|
(1 row)
----snip----
This crashes my little app (because of the empty row) which works fine
with Oracle:
----snip----
SQL> create table testi (n int, name varchar(40));
Table created.
SQL> insert into testi values (1, 'myname');
1 row created.
SQL> select sum(n) from testi where name='myname';
SUM(N)
----------
1
SQL> select * from testi where name='notthere';
no rows selected
SQL> select sum(n), name from testi where name='notthere' group by name;
no rows selected
----snip----
Which is the buggy one: Oracle, PostgreSQL or my Java-app?
Thanls,
Jochen
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Holtz | 1999-06-21 11:31:28 | Re: [GENERAL] 6.4.2 install on sparc solaris 2.6 |
Previous Message | Grigory Kljuchnikov | 1999-06-21 10:00:40 | Re: [GENERAL] 6.4.2 install on sparc solaris 2.6 |