Thread: Sorting with relevant blank spaces

Hi,
I need to understand why my Postgres 6.5.2 installation sorts results ignoring blanks.
I obtain

prata
prata gennaro m
prata roberto
prat de la riba enrique h
prat enrique h
pratesi alessandro
pratesi luigi
pratesi marco

How to obtain

prat de la riba enrique h
prat enrique h
prata
prata gennaro m
prata roberto
pratesi alessandro
pratesi luigi
pratesi marco

TIA. Stefano
--
Dott. Stefano Bargioni
Biblioteca della Pontificia Universita' della Santa Croce - Roma
<mailto:bargioni@usc.urbe.it>                  <http://www.usc.urbe.it>
Personal web page:    <http://www.usc.urbe.it/html/php.script?bargioni>
--- "Si apud bibliothecam hortulum habes, nihil deerit"  (Cicerone) ---

Hi,

if a certain column is declared as:

   TEXT[]

how does one retrieve the individual TEXT's from a ResultSet ?

Thanks in advance

======================================================================
   Mart Käsper                 E-mail            : mart@netsoftlund.se
   Netsoft Lund AB
   Bredgatan 17                Tel (in place)    : +46 46  19 04 95
   SE-222 21 Lund, Sweden      Tel (on the road) : +46 70 319 04 95
======================================================================
#include <std.disclaimer>
======================================================================

   Life can be broken down into just a single unit - either you do a
   certain thing, or you don't.

Stefano Bargioni <bargioni@usc.urbe.it> writes:
> I need to understand why my Postgres 6.5.2 installation sorts results ignoring blanks.

This would be a matter of the LOCALE you are running the code in.
You may want to run the postmaster with environment variable LANG=C
(or possibly LC_ALL=C, depending on your platform).

Caution: this is not something you can change on a whim, because
changing the sort order means any indexes you have on text columns
are now logically out-of-order and thus corrupt.  The safest way to
proceed is pg_dumpall, stop postmaster, change LANG, initdb, restart
postmaster, load data.  Don't forget to change your system boot script
to ensure the same LANG is provided when you reboot...

            regards, tom lane