X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id D2A5C30E88A for ; Sat, 14 Jun 2003 17:01:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 78133-06 for ; Sat, 14 Jun 2003 14:01:10 -0300 (ADT) Received: from postfix4-2.free.fr (postfix4-2.free.fr [213.228.0.176]) by svr1.postgresql.org (Postfix) with ESMTP id 0648030E943 for ; Sat, 14 Jun 2003 14:01:10 -0300 (ADT) Received: from camber (lns-p19-18-82-65-115-129.adsl.proxad.net [82.65.115.129]) by postfix4-2.free.fr (Postfix) with SMTP id 2CFE3C2A7 for ; Sat, 14 Jun 2003 19:01:07 +0200 (CEST) Date: Sat, 14 Jun 2003 19:01:27 +0200 From: Emmanuel Engelhart To: pgsql-sql@postgresql.org Subject: UNION & LIMIT & ORDER BY Message-Id: <20030614190127.51910c98.emmanuel@engelhart.org> Reply-To: emmanuel@engelhart.org X-Mailer: Sylpheed version 0.9.0claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: Sylpheed-Claws X-Face: .yA/kR]jt1}=pDmgdL:c\yRPc*9ZB\'-Go}-odUxl1Gw=`QsX)Kyn`p"sRjsOCm0}[gPR{\ EjNjQPJlD&rzsP)[z9.d6anUG.4; 0pZ0,*HI,HWb[]u't3x#|7i_G<[>)F0\.&:}%13HuQUvH5iWpd !^$5>8J8'uD_V1;x"_SJ=>=Hs82t=GjFlDH1LiKSWam+AF{"Z[Q2\D Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=SUBJ_ALL_CAPS, UPPERCASE_25_50, USER_AGENT X-Spam-Level: * X-Archive-Number: 200306/154 X-Sequence-Number: 13912 Hi Why this query doesn't work ? << SELECT '1' AS id FROM users ORDER BY id LIMIT 1 UNION SELECT '2' AS id FROM users >> And this one work ? << SELECT '1' AS id FROM users UNION SELECT '2' AS id FROM users ORDER BY id LIMIT 1 >> -- ------------------------------------------------------------------------- | Dans le cours d'un long gouvernement, on va au mal par une pente | | insensible, et ne remonte au bien que par un effort. | | Montesquieu, "de l'esprit des lois" livre V/VII | ------------------------------------------------------------------------- Emmanuel Engelhart alias Kelson | ICQ UIN : 53388731 | TEL 01.58.46.04.79