ORDER BY question - Mailing list pgsql-sql

From Christian Paul Cosinas
Subject ORDER BY question
Date
Msg-id 018701c674f2$756133d0$1e21100a@ghwk02002147
Whole thread Raw
In response to Re: Help with a seq scan on multi-million row table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ORDER BY question
List 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



pgsql-sql by date:

Previous
From:
Date:
Subject: Re: Help with a seq scan on multi-million row table
Next
From: Michael Glaesemann
Date:
Subject: Re: ORDER BY question