Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorting by an arbitrary criterion - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Sorting by an arbitrary criterion
Date
Msg-id 4A55D6D80200002500028659@gw.wicourts.gov
Whole thread Raw
In response to Sorting by an arbitrary criterion  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
Craig James <craig_james@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

There was a recent thread discussing ways to do that:

http://archives.postgresql.org/pgsql-admin/2009-07/msg00016.php

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sorting by an arbitrary criterion
Next
From: Alexander Staubo
Date:
Subject: Re: Sorting by an arbitrary criterion