On Tue, 8 Feb 2005 01:10 pm, CoL wrote: > hi, > > Berend Tober wrote, On 2/7/2005 22:20: > > I encountered what looks like unusually sorting behavior, and I'm wondering > > if > > anyone can tell me if this is supposted to happen (and then if so, why) or > > if > > this is a bug: > > > > > > SELECT * FROM sample_table ORDER BY 1; > > > > account_id,account_name > > 100,First account > > 110,Second account > > *115,Fifth account > > 120,Third account > > *125,Fourth account > > > > I would expect to see > > > > account_id,account_name > > *115,Fifth account > > *125,Fourth account > > 100,First account > > 110,Second account > > 120,Third account
With 8.0.0 C local, SQL_ASCII Database, I get the expected output. Regards Russell Smith ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
