Re: INDEX suggestion needed

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE>, pgsql-general(at)postgresql(dot)org
Subject: Re: INDEX suggestion needed
Date: 2002-12-11 18:49:11
Message-ID: 20021211184911.86297.qmail@web20808.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> wrote:
> My typical queries are like that:
> SELECT count(a_id) AS count
> FROM (
> SELECT DISTINCT a_id FROM stat_pages
> WHERE m_id = '35'
> AND visit >= '2002-09-01'
> AND visit <= '2002-09-30'
> ) AS foo;
>

You can do SELECT count(DISTINCT a_id) FROM ...

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Bax 2002-12-11 18:58:59 Re: INDEX suggestion needed
Previous Message Thomas Beutin 2002-12-11 18:43:51 INDEX suggestion needed