Custom sort

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'))

Art