Re: ORDER BY question - Mailing list pgsql-php

From Adrian Tineo
Subject Re: ORDER BY question
Date
Msg-id 001601c2de4e$a0176ba0$f8ddd8d9@supercable.es
Whole thread Raw
In response to ORDER BY question  ("Grant Henderson" <granth@fusion-advertising.co.uk>)
List 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


pgsql-php by date:

Previous
From: "Grant Henderson"
Date:
Subject: ORDER BY question
Next
From: "Markus Post"
Date:
Subject: PL/PGSQL