X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ECE519FA3A3 for ; Thu, 11 May 2006 00:51:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 00496-01 for ; Thu, 11 May 2006 00:50:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailer.eglobalreach.net (mail.opm.ph [202.124.128.22]) by postgresql.org (Postfix) with ESMTP id 201379F931E for ; Thu, 11 May 2006 00:50:57 -0300 (ADT) Received: from ghwk02002147 (mailer.eglobalreach.net [127.0.0.1]) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id k4B3oax08533 for ; Thu, 11 May 2006 11:50:36 +0800 From: "Christian Paul Cosinas" To: Subject: ORDER BY question Date: Thu, 11 May 2006 12:00:11 -0000 Message-ID: <018701c674f2$756133d0$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <26129.1147312429@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Thread-Index: AcZ0neXBevuSeQdlRYeOeZUTV2oIdQAVA2CQ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/96 X-Sequence-Number: 25127 Hi, For example I have a table like this ID Name 1 A 1 B 2 C 2 D And I have a Query like this: SELECT * FROM table ORDER BY ID. Would my result always give me the same order or is there may be a possible different result? For example? 1 B 1 A 2 D 2 C