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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-php

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

SELECT colum_name
FROM table_name
ORDER BY upper(colum_name);

For a list of support functios like upper() check this url:

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-2017 The PostgreSQL Global Development Group