X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id F271ED7958
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Sep 2005 12:03:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 87634-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Sep 2005 15:03:48 +0000 (GMT)
Received: from wolff.to (wolff.to [66.93.197.194])
	by svr1.postgresql.org (Postfix) with SMTP id 9D06BD8505
	for <pgsql-sql@postgresql.org>; Tue,  6 Sep 2005 12:03:45 -0300 (ADT)
Received: (qmail 32710 invoked by uid 500); 6 Sep 2005 15:03:40 -0000
Date: Tue, 6 Sep 2005 10:03:40 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: Help with UNION query
Message-ID: <20050906150340.GB30161@wolff.to>
Mail-Followup-To: Bruno Wolff III <bruno@wolff.to>,
	Andreas Joseph Krogh <andreak@officenet.no>, pgsql-sql@postgresql.org
References: <200509041914.33245.andreak@officenet.no>
	<200509042008.21080.andreak@officenet.no>
	<200509042054.02993.andreak@officenet.no>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200509042054.02993.andreak@officenet.no>
User-Agent: Mutt/1.5.6i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level: 
X-Archive-Number: 200509/61
X-Sequence-Number: 22608

On Sun, Sep 04, 2005 at 20:54:00 +0200,
  Andreas Joseph Krogh <andreak@officenet.no> wrote:
> 
> So, the question stands: any idea on how to rewrite the lower wuery to only 
> specify "ug.username='andreak'" once?

Why do you want to do that? This isn't going to help with performance and
may actually hurt. We may be able to suggest some other way to accomplish your
real objective if you told us what it was.