Re: planet "top posters" section

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: planet "top posters" section
Дата
Msg-id 201004221515.41891.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: planet "top posters" section  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: planet "top posters" section  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: planet "top posters" section
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: planet "top posters" section