GROUP BY and empty queries

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

Browse pgsql-general by date

  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