X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A58B563D2 for ; Mon, 14 Mar 2005 08:41:47 +0000 (GMT) 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 29121-05 for ; Mon, 14 Mar 2005 08:41:45 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 37268563BA for ; Mon, 14 Mar 2005 08:41:43 +0000 (GMT) Received: from gnari ([157.157.184.242] [157.157.184.242]) by quasar.skima.is with ESMTP; Mon, 14 Mar 2005 08:41:43 Z Subject: Re: sql question From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: George Essig Cc: Steven Verhoeven , pgsql-general@postgresql.org In-Reply-To: <6744b385050313211333b5d009@mail.gmail.com> References: <42318E5F.4080207@dmbr.ugent.be> <6744b385050313211333b5d009@mail.gmail.com> Content-Type: text/plain Date: Mon, 14 Mar 2005 08:41:49 +0000 Message-Id: <1110789710.12425.13.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/587 X-Sequence-Number: 74902 On Sun, 2005-03-13 at 23:13 -0600, George Essig wrote: > On Fri, 11 Mar 2005 13:26:07 +0100, Steven Verhoeven > wrote: > [snip problem] > select id, fref as ref from my_table > union > select id, mref as ref from my_table; union ALL (see other replies) gnari