From: Masaru Sugawara <rk73@sea.plala.or.jp>
To: Janning Vygen <vygen@gmx.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Joining three data sources.
Date: Thu, 20 Jun 2002 22:55:43 +0900
Message-ID: <20020620225440.A150.RK73@sea.plala.or.jp> (raw)
In-Reply-To: <200206200627.g5K6R8X31442@janning.planwerk6.local>
References: <20020619230842.91E2.RK73@sea.plala.or.jp>
<200206200627.g5K6R8X31442@janning.planwerk6.local>
On Thu, 20 Jun 2002 08:27:07 +0200
Janning Vygen <vygen@gmx.de> wrote:
> Oh thanks a lot. You pushed me in the right direction. i still get headache
> when trying to write complicated selects. there was something wrong
> in your statement
Oh! I slipped up. You are exactly right.
> but i was able to correct it by myself. Thanks for your help!!
> Are you able to type those queries in minutes?? It seems so ... amazing!
No. Actually, I may have spent a few hours before I was aware of
making use of Max/Min aggregations to divide the values of the
team_id into the team1_id or tema2_id.
>
> > As for Goal table, if it has a large number of the rows, you maybe
> > need to create a unique index on it.
>
> of course. it was just an example...
>
> kind regards
> janning
Regards,
Masaru Sugawara
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rk73@sea.plala.or.jp, vygen@gmx.de
Subject: Re: Joining three data sources.
In-Reply-To: <20020620225440.A150.RK73@sea.plala.or.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox