Re: sort case insensitive
| От | Alexander Pucher |
|---|---|
| Тема | Re: sort case insensitive |
| Дата | |
| Msg-id | 3DD96398.6080901@atlas.gis.univie.ac.at обсуждение исходный текст |
| Ответ на | Re: sort case insensitive (Frank Bax <fbax@sympatico.ca>) |
| Список | pgsql-novice |
Thankx, works!! Best regards, alex Frank Bax wrote: > try: ORDER BY lower(fieldname) > > > At 04:43 PM 11/18/02, Alexander Pucher wrote: > >> hi, >> >> can someone give me a quick hint on how to sort case insenstive. >> >> my 'select' clause with an 'order by' gives me this result: >> >> Green >> Miller >> adams >> >> by of course, I would like to get >> >> adams >> Green >> Miller >> >> Best Regards, >> alex >> >> -- >> ________________________________________________________ >> >> Institut fuer Geographie und Regionalforschung >> Universitaet Wien >> Kartografie und Geoinformation >> >> Departement of Geography and Regional Research >> University of Vienna >> Cartography and GIS >> >> Universitaetstr. 7, A-1010 Wien, AUSTRIA >> >> Tel: (+43 1) 4277 48644 >> Fax: (+43 1) 4277 48649 >> E-mail: alexander.pucher@univie.ac.at >> >> FTP: ftp://ftp.gis.univie.ac.at >> WWW: http://www.gis.univie.ac.at/karto >> -------------------------------------------------------- >> Virtual Map Forum: http://www.gis.univie.ac.at/vmf >> -------------------------------------------------------- >> >> M$ is not the answer. M$ is the question! >> No is the answer -- Eric Naggum >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >> -- ________________________________________________________ Institut fuer Geographie und Regionalforschung Universitaet Wien Kartografie und Geoinformation Departement of Geography and Regional Research University of Vienna Cartography and GIS Universitaetstr. 7, A-1010 Wien, AUSTRIA Tel: (+43 1) 4277 48644 Fax: (+43 1) 4277 48649 E-mail: alexander.pucher@univie.ac.at FTP: ftp://ftp.gis.univie.ac.at WWW: http://www.gis.univie.ac.at/karto -------------------------------------------------------- Virtual Map Forum: http://www.gis.univie.ac.at/vmf -------------------------------------------------------- M$ is not the answer. M$ is the question! No is the answer -- Eric Naggum
В списке pgsql-novice по дате отправления: