Received: from srv-mn07.sicor.net (root@[62.208.48.10]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA37394 for ; Fri, 17 Dec 1999 08:12:28 -0500 (EST) (envelope-from stephan_bauer@gmx.de) Received: from gmx.de (p3E9D4BB0.dip0.t-ipconnect.de [62.157.75.176]) by srv-mn07.sicor.net (8.9.3/8.9.3) with ESMTP id OAA10941; Fri, 17 Dec 1999 14:26:44 +0100 Message-ID: <385A3699.36A4E9FF@gmx.de> Date: Fri, 17 Dec 1999 14:11:53 +0100 From: Stephan Bauer X-Mailer: Mozilla 4.6 [de] (Win98; U) X-Accept-Language: de MIME-Version: 1.0 To: pgsql-sql@postgresql.org CC: Dietmar Kling Subject: select with group by problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, could anyone tell me why the second select statement returns one row. regards Stephan xtra=> select * from warenkorb; cookie|datum|artnr|artnr1|artnr2|artikelname|farbe|groesse|menge|preis ------+-----+-----+------+------+-----------+-----+-------+-----+----- (0 rows) xtra=> SELECT artnr, artnr1, artnr2, artikelname, farbe, groesse, SUM( menge ), preis FROM warenkorb WHERE cookie = 'asdfasdf' GROUP BY artnr, artnr1, artnr2, artikelname, farbe, groesse, preis; artnr|artnr1|artnr2|artikelname|farbe|groesse|sum|preis -----+------+------+-----------+-----+-------+---+----- | | | | | | | (1 row)