Craig James <craig_james@xxxxxxxxxxxxxx> 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 There was a recent thread discussing ways to do that: http://archives.postgresql.org/pgsql-admin/2009-07/msg00016.php -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance