Oder by not working

From: "Blanco, Jose" <blancoj(at)umich(dot)edu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Oder by not working
Date: 2008-08-06 18:44:14
Message-ID: E0217C87D1BA1043AC897ACFA468CEE60120BA3B@ECLUST2-VS3.adsroot.itcs.umich.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I was hoping that the a newer version of postgres ( 8.1.11 ) would solve
the problem we see when we use order by to get a listing of names. Let
me explain the problem.

Suppose we have the following 3 names in a table:

Ta, A
Ta, Z
Tab, A

I would expect them to show up in the oder shown above when odering by
by name, but instead I get:

Ta, A
Tab, A
Ta, Z

Which as you can see is not really the desired behavior. I created a
test table and loaded these values into a field of type text, and then
issued the following query:

select * from test order by 1;
name
--------
Ta, A
Tab, A
Ta, Z
(3 rows)

I believe I asked about this when I was on version 7.3.15, and was told
this bug would get fixed in a later version. Is there some config
parameter I'm not aware of that solves this problem.

Thank you!
Jose

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gregory Stark 2008-08-06 19:28:17 Re: Hmm, nodeUnique doesn't really support backwards scan too well
Previous Message Tom Lane 2008-08-06 15:20:49 Re: BUG #4341: planner doesn't using index for = operation