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'))
The simplest direct mapping would probably be a CASE statement (see the
PostgreSQL documentation). As others have noted, enums and Pl/PgSQL
functions are also options.
--
Craig Ringer