> On Thu, Jul 09, 2009 at 09:26:42AM -0700, Craig James wrote: > You can do it like this: > select c.* > from categories c, ( values (1, 'z'), (2, 'a'), (3, 'b'), (4, 'w'), (5, > 'h') ) as o (id, ordering) on c.id = o.id > order by o.ordering Another option would be: select c.* from categories c order by case(c.category) when 1 then 'z' when 2 then 'a' then 3 then 'b' when 4 then 'w' when 5 then 'h' end; Matthew Hartman Programmer/Analyst Information Management, ICP Kingston General Hospital -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
