ORDER BY question

From: "Christian Paul Cosinas" <cpc(at)cybees(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: ORDER BY question
Date: 2006-05-11 12:00:11
Message-ID: 018701c674f2$756133d0$1e21100a@ghwk02002147
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-05-11 13:46:00 Re: Help with a seq scan on multi-million row table
Previous Message Markus Schaber 2006-05-11 10:33:55 Re: Help with a seq scan on multi-million row table