Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AA90F9F954C for ; Sun, 4 Nov 2007 12:00:41 -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 58207-02 for ; Sun, 4 Nov 2007 12:00:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp158.iad.emailsrvr.com (smtp158.iad.emailsrvr.com [207.97.245.158]) by postgresql.org (Postfix) with ESMTP id 9460F9F9509 for ; Sun, 4 Nov 2007 12:00:36 -0400 (AST) Received: from relay5.relay.iad.emailsrvr.com (localhost [127.0.0.1]) by relay5.relay.iad.emailsrvr.com (SMTP Server) with ESMTP id 2CA9E655475; Sun, 4 Nov 2007 11:00:36 -0500 (EST) Received: by relay5.relay.iad.emailsrvr.com (Authenticated sender: chander-AT-otg-nc.com) with ESMTP id E20A9655431; Sun, 4 Nov 2007 11:00:35 -0500 (EST) Message-ID: <472DEC21.3040603@otg-nc.com> Date: Sun, 04 Nov 2007 10:58:25 -0500 From: Chander Ganesan User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Dave Page CC: "Marc G. Fournier" , Kevin Hunter , "Joshua D. Drake" , Postgres WWW List , Peter Eisentraut 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> In-Reply-To: <472DE115.2050902@postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/100 X-Sequence-Number: 12878 Dave Page wrote: > Marc G. Fournier wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> >> >> - --On Sunday, November 04, 2007 01:53:35 -0400 Chander Ganesan >> wrote: >> >>> In the next six months, there are 21 events in 4 countries >>> from 13 different companies, including PostgreSQL Administration, and >>> PostgreSQL >>> Database Implement ion and Performance Tuning events. >> >> You'd need to go something like: >> >> Over the next 6 months, there are 21 courses being >> offered in 4 countries, split up as:

3 - Administration >>
2 - Implementation >>
9 - Tuning >>

>> >> Or something like that ... > > That would require a much more significant redesign of the way we > handle events which is not something I have time for atm > unfortunately. For the record, I think we'd want to properly seperate > them from the other events and allow them to be categorised in one or > more categories (a single course might cover multiple topics). 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... > > /D > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com