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