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

Re: A little bug in postgreSQL

From: Neil Conway <neilc(at)samurai(dot)com>
To: Baiju MP <baiju(at)ipath(dot)net(dot)in>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: A little bug in postgreSQL
Date: 2002-11-27 03:27:40
Message-ID: 1038367660.1741.9.camel@tokyo (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
On Tue, 2002-11-26 at 13:35, Baiju MP wrote:
> At present the all other database, providing an option to set 
> developers own order with the order  by  statement.
> eg : SELECT ......
>        FROM  ......
>         ORDER BY 1 like 'A%' like 'H%' like 'G%' like 'C%' 

Can you elaborate on exactly what behavior you'd expect this to produce?
We already support this syntax:

    [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]

Cheers,

Neil

-- 
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC




In response to

pgsql-bugs by date

Next:From: Jean-Christian ImbeaultDate: 2002-11-27 08:48:31
Subject: 7.3RC2 does not have datetime() function?
Previous:From: Neil ConwayDate: 2002-11-27 03:24:03
Subject: Re: Invalid free/delete

pgsql-general by date

Next:From: Jean-Christian ImbeaultDate: 2002-11-27 03:35:47
Subject: 7.3RC2 install woes
Previous:From: Jean-Christian ImbeaultDate: 2002-11-27 03:24:01
Subject: Re: '7.3RC2 install problem

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