Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e65CX2S61390 for ; Wed, 5 Jul 2000 08:33:03 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id PAA15744 for ; Wed, 5 Jul 2000 15:32:53 +0300 Date: Wed, 5 Jul 2000 15:32:53 +0300 (EEST) From: Antti Linno To: pgsql-sql@postgresql.org Subject: GROUP by finish&&last day of month Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200007/37 Ok, if I want to get non-aggregat data in groups, I use order by. This group by seemed so logical though, but the fruit that u can't have, is usually the most sweet. New question, how to get the last day of month(order data by last day of month). And to prevent chain letter from misunderstanding, no I don't intend to look it up from calendar and then input it manually. A.