Skip site navigation (1) Skip section navigation (2)

Re: help with query: advanced ORDER BY...

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: me(at)alternize(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: help with query: advanced ORDER BY...
Date: 2006-01-15 01:38:10
Message-ID: 20060115013810.GA8627@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Sat, Jan 14, 2006 at 09:32:03PM +0100, me(at)alternize(dot)com wrote:
> >Something like this might work:
> >
> >SELECT * FROM table1
> >ORDER BY field1,
> >        CASE WHEN field1 THEN field2 ELSE NULL END,
> >        CASE WHEN field1 THEN field3 ELSE NULL END,
> >        CASE WHEN field1 THEN NULL ELSE field3 END,
> >        CASE WHEN field1 THEN NULL ELSE field2 END;
> 
> 
> it indeed does, thanks alot. will pgsql still use the indices when ordering 
> through CASE?

I don't think so, unless you define a multicolumn index on those
specific expressions.

Why the different ordering?  What are you doing?

-- 
Michael Fuhr

In response to

Responses

pgsql-novice by date

Next:From: meDate: 2006-01-15 02:15:18
Subject: Re: help with query: advanced ORDER BY...
Previous:From: meDate: 2006-01-14 20:32:03
Subject: Re: help with query: advanced ORDER BY...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group