Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: (repost) Help understanding expressions in order by clause
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Steve Midgley <public(at)misuse(dot)org>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: (repost) Help understanding expressions in order by clause
- Date: Thu, 25 Oct 2007 13:03:21 -0400
- Message-id: <18291.1193331801@sss.pgh.pa.us> <text/plain>
Steve Midgley <public(at)misuse(dot)org> writes: > select * from test_order > order by id <> 3, email > --sql end > Putting the expression "id <> 3" causes the id of 3 to sort to the TOP > of the list. This statement does the same thing: > select * from test_order > order by id = 3 DESC, email > I know there is a good, rational reason for this, and I'm hoping > someone will explain it to me? These expressions yield boolean true or false, and false sorts before true. regards, tom lane
- References:
- (repost) Help understanding expressions in order by clause
- From: Steve Midgley
- (repost) Help understanding expressions in order by clause
- Prev by Date: Re: request for help with COPY syntax
- Next by Date: JOINing based on whether an IP address is contained within a CIDR range?
- Previous by thread: (repost) Help understanding expressions in order by clause
- Next by thread: JOINing based on whether an IP address is contained within a CIDR range?
- Indexes: