From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Very odd order by behavior |
Date: | 2001-02-05 04:00:08 |
Message-ID: | 004c01c08f28$214d6d00$0200000a@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-05 04:04:31 | Re: pg_ctl wish list |
Previous Message | Bruce Momjian | 2001-02-05 03:42:10 | Re: contrib |