subject:"\[GENERAL\] ORDER BY results"

Re: [GENERAL] ORDER BY results

2005-09-22 Thread Tom Lane

Howard Cole <[EMAIL PROTECTED]> writes: > I have a query which presents results sorted using the SQL "ORDER BY... > LIMIT". Now my question is... if the column that the order refers to > has some repeated data, will the order of results always be the same? No. You need to add more columns to

Re: [GENERAL] ORDER BY results

2005-09-22 Thread Michael Fuhr

On Thu, Sep 22, 2005 at 02:19:00PM +0100, Howard Cole wrote: > I have a query which presents results sorted using the SQL "ORDER BY... > LIMIT". Now my question is... if the column that the order refers to > has some repeated data, will the order of results always be the same? Not necessarily

[GENERAL] ORDER BY results

2005-09-22 Thread Howard Cole

Hi, I have a query which presents results sorted using the SQL "ORDER BY... LIMIT". Now my question is... if the column that the order refers to has some repeated data, will the order of results always be the same? For instance, say I have a table as follows: create table example {id seria