Re: Change in behaviour of ORDER BY clause in PG7.3

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Ollie Clark <oliverc(at)comp(dot)leeds(dot)ac(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Change in behaviour of ORDER BY clause in PG7.3
Date: 2003-11-28 21:09:13
Message-ID: Pine.LNX.4.44.0311282208420.19468-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ollie Clark writes:

> Since upgrading to 7.3 I've noticed that the ORDER BY clause seems to
> ignore leading spaces/punctuation for eg we have a simple table with 6
> rows containing:

You need to set the right locale. You appear to expect the "C" locale, so
you need to tell initdb about it.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2003-11-28 21:43:11 Re: statistics about tamp tables ...
Previous Message Rod Taylor 2003-11-28 20:49:25 Re: $Id$ -> $PostgreSQL$ Change