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:
1 = 'z'
2 = 'a'
3 = 'b'
4 = 'w'
5 = 'h'
So when I get done, the sort order should be 2,3,5,4,1.
I
On Thu, Jul 9, 2009 at 5:26 PM, Craig Jamescraig_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:
1 = 'z'
2 = 'a'
3 =
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
On Thu, Jul 9, 2009 at 5:26 PM, Craig Jamescraig_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)
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
There was a recent thread discussing ways to do that:
On Thu, Jul 9, 2009 at 6:26 PM, Craig Jamescraig_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:
1 = 'z'
2 = 'a'
3 =
On Thu, Jul 09, 2009 at 09:26:42AM -0700, Craig James 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:
1 = 'z'
2 = 'a'
3 = 'b'
4 = 'w'
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
2009/7/9 Tom Lane t...@sss.pgh.pa.us:
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
On Thu, Jul 9, 2009 at 5:26 PM, Craig Jamescraig_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