From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Very odd order by behavior - followup |
Date: | 2001-02-05 04:05:13 |
Message-ID: | 005701c08f28$d751f3f0$0200000a@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I found the problem. User error, it's been a long Sunday.
Sorry!
-Mitch
----- Original Message -----
From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-hackers(at)postgresql(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-05 05:20:31 | Re: Like vs '=' bug with indexing |
Previous Message | Tom Lane | 2001-02-05 04:04:31 | Re: pg_ctl wish list |