Re: Custom sort - Mailing list pgsql-general

From Jeff Davis
Subject Re: Custom sort
Date
Msg-id 1218740786.30569.4.camel@dell.linuxdev.us.dell.com
Whole thread Raw
In response to Custom sort  (Artacus <artacus@comcast.net>)
List pgsql-general
On Thu, 2008-08-14 at 10:22 -0700, Artacus wrote:
> Can you define a custom sort in postgres? For instance in mysql, you
> could do something like (I forget the exact syntax)
>
> ORDER BY FIND_IN_SET(column_name, ('one','two','three'))
>

You can sort by any column, or arbitrary expression or function.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: SCassidy@overlandstorage.com
Date:
Subject: Re: PostgreSQL arrays and DBD
Next
From: "Schwaighofer Clemens"
Date:
Subject: Re: Postgres 8.3 is not using indexes