Re: Custom sort - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Custom sort
Date
Msg-id 48A46CC1.8050301@lelarge.info
Whole thread Raw
In response to Custom sort  (Artacus <artacus@comcast.net>)
Responses Re: Custom sort  (Artacus <artacus@comcast.net>)
List pgsql-general
Artacus a écrit :
> 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'))
>

I don't really know this syntax but isn't it something like :
  ORDER BY column_name='one', column_name='two', column='three'  ?


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Artacus
Date:
Subject: Custom sort
Next
From: Bill Moran
Date:
Subject: Re: Custom sort