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