Re: planet "top posters" section - Mailing list pgsql-www

From Robert Treat
Subject Re: planet "top posters" section
Date
Msg-id 201004221515.41891.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: planet "top posters" section  (Magnus Hagander <magnus@hagander.net>)
Responses Re: planet "top posters" section
List pgsql-www
On Thursday 22 April 2010 13:20:40 Magnus Hagander wrote:
> On Thu, Apr 22, 2010 at 03:18, Robert Treat
>
> <xzilla@users.sourceforge.net> wrote:
> > More importantly, there's a flaw in your query me thinks. OmniTI
> > currently shows having 9 posts in the team section, which also matches
> > the breakdown of my cohorts (4,3,2) in the top posters section, however I
> > also have a blog post on the 13th, so I'd think that we should have at
> > least 10 posts on our "Team", no? I'm guessing others might be off as
> > well, I only noticed cause I knew I had blogged recently.
>
> Uh, que? There may be more posts now, but I see:
>
> Hubert - 4
> Theo - 3
> You - 2
>
> Which is 9, which happens to be what's listed as OmnitTI.
>
> I don't think you get to count yourself twice ;)

:-)  My bad, I see one of my cohorts isn't actually listed as being part of 
the OmniTI team, perhaps we'll have to fix that. Of course that also means that 
I'm not listed in the top posters section, even though I have 2 posts (like 
most of the other people). Guessing you sort it by first name, what you really 
need is some magic window query to grab top n plus ties and display that. In 
the meantime, I can change my name to Bob I guess :-P 

-- 
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com


pgsql-www by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: planet "top posters" section
Next
From: Magnus Hagander
Date:
Subject: Re: planet "top posters" section