Обсуждение: sort case insensitive
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
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 >
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