Postgres Pro
Downloads
Home   >   mailing lists

Sorting with relevant blank spaces - Mailing list pgsql-general

From Stefano Bargioni
Subject Sorting with relevant blank spaces
Date
Msg-id 3A24DE6F.C1C1543@usc.urbe.it
Whole thread Raw
Responses Retrieving arrays through JDBC  (Mart Käsper <mart@netsoftlund.se>)
Re: Sorting with relevant blank spaces  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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) ---

pgsql-general by date:

Previous
From: "Gordan Bobic"
Date:
Subject: Database cluster?
Next
From: Peter Maas
Date:
Subject: function to return query result