From: Josh Berkus <josh@agliodbs.com>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Subject: Re: Indexing UNIONs
Date: Thu, 18 Jul 2002 10:30:22 -0700
Message-ID: <200207181030.22754.josh@agliodbs.com> (raw)
In-Reply-To: <20020718022901.GA11498@wolff.to>
References: <20020716114553.GB29323@wolff.to>
<200207171719.22224.josh@agliodbs.com>
<20020718022901.GA11498@wolff.to>
Bruno,
> My suggestion:
> SELECT t3.id, coalesce(t1.name, t2.name), t1.abbreviation,
> coalesce(t1.juris_id, t2.juris_id) from
> (t3 left join t1 using (id)) left join t2 using (id);
Cool! I didn't think of that. I'll give it a try.
-Josh
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: josh@agliodbs.com, bruno@wolff.to
Subject: Re: Indexing UNIONs
In-Reply-To: <200207181030.22754.josh@agliodbs.com>
* 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