| 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: | Whole Thread | Raw Message | 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 |