Re: Very odd order by behavior - followup
От | Mitch Vincent |
---|---|
Тема | Re: Very odd order by behavior - followup |
Дата | |
Msg-id | 005701c08f28$d751f3f0$0200000a@windows обсуждение исходный текст |
Ответ на | Very odd order by behavior ("Mitch Vincent" <mitch@venux.net>) |
Список | pgsql-hackers |
I found the problem. User error, it's been a long Sunday. Sorry! -Mitch ----- Original Message ----- From: "Mitch Vincent" <mitch@venux.net> To: <pgsql-hackers@postgresql.org> Sent: Sunday, February 04, 2001 11:00 PM Subject: Very odd order by behavior > FreeBSD 4.2, PostgreSQL 7.0.3 > > The attached file is the schema and data to the app_degrees table. Now check > this out : > > select * from app_degrees gives (expected) : > > degree_id | abbr | description > -----------+--------+------------------------------------------ > 1818 | ACC | Accounting [ACC] > 1819 | ACD | Acoustics [ACD] > 1820 | ADV | Advertising [ADV] > > select * from app_degrees order by abbr ASC gives : > > degree_id | abbr | description > -----------+--------+------------------------------------------ > 1818 | ACC | Accounting [ACC] > 1818 | ACC | Accounting [ACC] > 1819 | ACD | Acoustics [ACD] > 1819 | ACD | Acoustics [ACD] > 1820 | ADV | Advertising [ADV] > 1820 | ADV | Advertising [ADV] > > Either I'm seeing double or something isn't right here :-) > > Thanks for any insights. > > -Mitch > > >
В списке pgsql-hackers по дате отправления: