Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 86649635A15 for ; Thu, 6 Aug 2009 11:21:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67383-02-3 for ; Thu, 6 Aug 2009 14:21:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id BD343632A59 for ; Thu, 6 Aug 2009 11:21:12 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0MKt2u-1MZ3q93FRK-000daz; Thu, 06 Aug 2009 16:21:10 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1MZ3q9-0008J0-00 for pgsql-sql@postgresql.org; Thu, 06 Aug 2009 16:21:09 +0200 Date: Thu, 6 Aug 2009 16:21:09 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: two records per row from query Message-ID: <20090806142109.GL22410@a-kretschmer.de> References: <200908051651.13235.jfabiani@yolo.com> <20090806052108.GA22410@a-kretschmer.de> <200908060648.23486.jfabiani@yolo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200908060648.23486.jfabiani@yolo.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19WWnlYYiJldmXYDf6869Ww8W29tazn6H2cGbM c2Ez03VuPK8+S1SltPBcl9g/ENcwRJL6Zz9K9F/K0eoDDmDRk0 BXLG7uff9iHg33rWcgHmQ== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/27 X-Sequence-Number: 32936 In response to John : > Thanks - the sessionid's in fact do match. It's just that I can have more > than two (2) classes per sessionid. So mytable might look like: > select * from mytable > 1 2009/01/01 2101 > 2 2009/01/02 2101 > 3 2009/02/05 2101 > 4 2009/02/15 2101 > 5 2009/02/25 2101 Can you show/explain, which rows in your example contains now the values for the new row? Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net