Re: query optimization question

From: Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: query optimization question
Date: 2002-11-08 14:22:38
Message-ID: 20021108232146.DA83.RK73@sea.plala.or.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 07 Nov 2002 09:57:27 +0100
Christoph Haller <ch(at)rodos(dot)fzk(dot)de> wrote:

> > ORDER BY proj.project_id ;
>
> What about simply replacing ORDER BY proj.project_id ; by
> GROUP BY project_id, marketing_name ;

You're right. Thanks a lot.

Regards,
Masaru Sugawara

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-11-08 15:56:43 Re: pg_dump, no inserts but \copy?
Previous Message Daniel Schuchardt 2002-11-08 13:24:43 Re: Alter table