Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 4192D26E75F for ; Mon, 2 Apr 2012 06:11:55 -0300 (ADT) Received: from hub.ringways.co.uk ([77.86.27.30] helo=mail.ringways.co.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SEdIo-0003jC-9A for pgsql-sql@postgresql.org; Mon, 02 Apr 2012 09:11:55 +0000 Received: from localhost ([127.0.0.1] helo=mail.ringways.co.uk) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1SEdIU-0007DP-S3 for pgsql-sql@postgresql.org; Mon, 02 Apr 2012 10:11:36 +0100 Received: from eddie.ringways.co.uk ([10.1.1.115] helo=eddie.ringways.co.uk) by mail.ringways.co.uk with ESMTP id qABUgeSu21897; Mon, 2 Apr 2012 10:11:30 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: "pgsql-sql@postgresql.org" Subject: Re: Wrong output from union Date: Mon, 2 Apr 2012 10:11:31 +0100 User-Agent: KMail/1.9.10 References: <201203281501.38835.gary.stainburn@ringways.co.uk> <2F810199-0078-400F-AF95-F04F6BFAB4B0@yahoo.com> In-Reply-To: <2F810199-0078-400F-AF95-F04F6BFAB4B0@yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201204021011.31071.gary.stainburn@ringways.co.uk> X-SpamTest-Envelope-From: gary.stainburn@ringways.co.uk X-SpamTest-Info: Profiles 20401 [Mar 31 2011] X-SpamTest-Info: {TO: suspicious real name} X-SpamTest-Method: none X-SpamTest-Rate: 10 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20110331T110535 #5151353, check: 20120402 clean X-Spam-Score: -51.5 (---------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie.ringways.co.uk", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: Thanks for this David. Does anyone know why it too until Saturday for my post to appear on the listr? Gary [...] Content analysis details: (-51.5 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP -2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE RING_SAFE 0.1 AWL AWL: From: address is in the auto white-list X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/1 X-Sequence-Number: 36478 Thanks for this David. Does anyone know why it too until Saturday for my post to appear on the listr? Gary On Saturday 31 March 2012 02:19:50 David Johnston wrote: > Documented behavior. Please read the section on UNION for the why and the > proper alternative syntax: > > http://www.postgresql.org/docs/9.0/interactive/sql-select.html > -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk