Very odd order by behavior

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

Responses

Browse pgsql-hackers by date

  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