Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E8B559F9477
	for <pgsql-www-postgresql.org@postgresql.org>;
	Sun,  4 Nov 2007 18:28:57 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 34693-05 for <pgsql-www-postgresql.org@postgresql.org>;
	Sun,  4 Nov 2007 18:28:55 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140])
	by postgresql.org (Postfix) with ESMTP id 12ACC9F9465
	for <pgsql-www@postgresql.org>; Sun,  4 Nov 2007 18:28:54 -0400 (AST)
Received: from snake.local ([89.243.37.134]) (authenticated bits=0)
	by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id lA4MSYe9028480
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Sun, 4 Nov 2007 22:28:36 GMT
Message-ID: <472E4793.3010504@postgresql.org>
Date: Sun, 04 Nov 2007 22:28:35 +0000
From: Dave Page <dpage@postgresql.org>
User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728)
MIME-Version: 1.0
To: Chander Ganesan <chander@otg-nc.com>
CC: "Marc G. Fournier" <scrappy@hub.org>, Kevin Hunter <hunteke@earlham.edu>,
	"Joshua D. Drake" <jd@commandprompt.com>,
	Postgres WWW List <pgsql-www@postgresql.org>,
	Peter Eisentraut <peter_e@gmx.net>
Subject: Re: [SPAM] Re: Training events policy ... first test
 case
References: <200711031703310000@114527600>	<20071103142105.2d29bc1b@scratch>
	<472D02A3.1070404@postgresql.org> <20071103205146.63a6997c@scratch>
	<472D505C.8010009@earlham.edu>
	<30F7311191EA4127FE35229B@ganymede.hub.org>
	<472D5E5F.8070703@otg-nc.com>
	<9599AD77F626EA5EFDBE4859@ganymede.hub.org>
	<472DE115.2050902@postgresql.org> <472DEC21.3040603@otg-nc.com>
In-Reply-To: <472DEC21.3040603@otg-nc.com>
X-Enigmail-Version: 0.95.5
OpenPGP: url=http://www.pgadmin.org/pgp/davepage.pgp
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/116
X-Sequence-Number: 12894

Chander Ganesan wrote:
> I think perhaps not.  We already have course titles...and vendors
> consistently use the same name for their courses.  We could simply take
> the course names, their counts, and when the most recent of any
> particular group of courses (start date) is.  Then list the three most
> recent (in terms of start date) along with a count as to the number of
> times they are offered...
> 
> Like: Upcoming courses:
> 
> PostgreSQL Administration (14 events)
> PostgreSQL Cool Tricks and Stuff (3 events)
> PostgreSQL for Dummies (1 event)
> plus 4 Other events...
> 
> If you can send me some DDL I can write up a sample query...

Well thats not exactly the same as was originally suggested, and in fact
does little more than to force events to be grouped by what could easily
be minor differences in phrasing:

PostgreSQL Administration for Beginners (3 events)
PostgreSQL Administration 101 (5 events)
Getting started with PostgreSQL (2 events)
Beginning PostgreSQL (4 events).

If we want to do something like that it needs to be done properly by
(for example) pre-defining some set categories to ensure we list things
appropriately.

Regards, Dave.