Skip site navigation (1) Skip section navigation (2)

Re: ORDER BY question

From: "Adrian Tineo" <adriantineo(at)softhome(dot)net>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: ORDER BY question
Date: 2003-02-27 10:54:06
Message-ID: 001601c2de4e$a0176ba0$f8ddd8d9@supercable.es (view raw or flat)
Thread:
Lists: pgsql-php

>Is there any way to do a case insensitive sort?.

Try: 
SELECT colum_name
FROM table_name
ORDER BY upper(colum_name);

For a list of support functios like upper() check this url:
http://www.postgresql.org/docs/aw_pgsql_book/node92.html

_________
Adrian Tineo


In response to

pgsql-php by date

Next:From: Markus PostDate: 2003-02-27 18:29:57
Subject: PL/PGSQL
Previous:From: Grant HendersonDate: 2003-02-27 10:09:58
Subject: ORDER BY question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group