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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-php by date

  From Date Subject
Next Message Markus Post 2003-02-27 18:29:57 PL/PGSQL
Previous Message Grant Henderson 2003-02-27 10:09:58 ORDER BY question