Received: from mail2.rogers.com (mail2.rogers.com [142.146.31.22]) by postgresql.org (Postfix) with ESMTP id AAF28475451 for ; Fri, 26 Apr 2002 12:04:44 -0400 (EDT) Received: from rssrgesnxd.rogers.com (rssrgesnxd [209.112.33.10]) by mail2.rogers.com (8.10.2+Sun/8.10.2) with ESMTP id g3QG6nn00118 for ; Fri, 26 Apr 2002 12:06:49 -0400 (EDT) Received: by rci.rogers.com with Internet Mail Service (5.5.2653.19) id ; Fri, 26 Apr 2002 12:04:28 -0400 Message-ID: <44586AAA5ECBD511A6520004AC2589A652D81F@rssesnexg.rogers.com> From: Robert Wynter To: "'pgsql-sql@postgresql.org'" Subject: union query format Date: Fri, 26 Apr 2002 12:04:12 -0400 Importance: low X-Priority: 5 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200204/332 X-Sequence-Number: 7596 Hi I'm trying to combine 3 query's in a union query as follows: rowdate nco nca nch aht asa svl %abandon With Query 1; 04/01/02 1000 500 500 450 23 .23 .50 04/02/02 2000 500 1500 450 23 .23 .50 plus Query 2; wtd 3000 1000 2000 450 23 .23 .50 and Query 3; mtd 3000 1000 2000 450 23 .23 .50 I have 2 problems once the Union Query has run. 1. because Query 2 & 3 are text, it's forcing Query 1 into text and the date order is all messed up. 2. I need to formate the fileds for svl & % abandon as a percentage.