=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryz...@gmail.com> writes:
> On Thu, Jul 9, 2009 at 5:26 PM, Craig James<craig_ja...@emolecules.com> wrote:
>> Suppose I have a large table with a small-cardinality CATEGORY column (say,
>> categories 1..5). Â I need to sort by an arbitrary (i.e. user-specified)
>> mapping of CATEGORY, something like this:
> you can create translation table, join it, and sort by its key.
Much easier to
ORDER BY CASE category WHEN 'z' THEN 1 WHEN 'a' THEN 2 ... END
Actually, consider putting the CASE into a function and doing
ORDER BY sort_order(category)
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
