order by for strings

From: "Rick Gigger" <rgigger(at)leadership-solutions(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: order by for strings
Date: 2003-12-11 17:45:02
Message-ID: 003701c3c00e$81f52e30$0700a8c0@trogdor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two postgres 7.2 servers. One is running 7.2.3 and one is running
7.2.4. I am querying for a word list and doing an order by on the word
field.

On the 7.2.3 server it is ordering like this:

a
A
b
B
c
C

which is what I want. But on the 7.2.4 server it is doing it like this:

A
B
C
a
b
c

Is this a change from 7.2.3 to 7.2.4 or a configure or compile option that I
set differently on the two systems?

Thanks,

rg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-12-11 18:04:09 Re: [NOVICE] PostgreSQL Training
Previous Message Netto 2003-12-11 17:35:39 Is it not datestyle that determines date format output?