Thread: A little bug in postgreSQL

A little bug in postgreSQL

From
"Baiju MP"
Date:
Sir,

We are using postgreSQL for two years for our projects.
It's fine and working well and meets all out requirements.
But one think I could find when comparing with other simple
databases is I am mentioning here . Hope your developing team=20
will consider this also while releasing the new version.

At present the all other database, providing an option to set=20
developers own order with the order  by  statement.
eg : SELECT ......
       FROM  ......
        ORDER BY 1 like 'A%' like 'H%' like 'G%' like 'C%'=20

Please try to add this feature also on next version .

Regards,
Baiju MP
                         \\\\\|/////
                         |  ~  ~  |=20
                        (-   0 0  -)
        ----------oOOo---(_)---oOOo--------------
=20=20=20=20=20=20=20=20=20=20=20=20
             Baiju MP,
             iPath India (P) LtdG-358,
             Panampilly Nagar,
             Cochin - 36
                      oooO=20=20=20=20=20=20=20=20=20=20=20
        ---------------(     )-----Oooo---------------=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20
                        \   (      (     )
                          \_)       )  /
                                    (_/

Re: A little bug in postgreSQL

From
Neil Conway
Date:
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@samurai.com> || PGP Key ID: DB3C29FC