Sorting with relevant blank spaces

From: Stefano Bargioni <bargioni(at)usc(dot)urbe(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Sorting with relevant blank spaces
Date: 2000-11-29 10:46:06
Message-ID: 3A24DE6F.C1C1543@usc.urbe.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)usc(dot)urbe(dot)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) ---

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2000-11-29 10:46:55 Access restriction
Previous Message Gordan Bobic 2000-11-29 09:20:58 Database cluster?