On Wed, 27 Nov 2002, Baiju MP wrote:
[Note, -bugs is the wrong place for this sort of message,
-general is more appropriate]
> 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
> will consider this also while releasing the new version.
>
> 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%'
I believe you can do this sort of thing already in postgresql by
defining an operator that provides the ordering you want and
doing ORDER BY 1 USING operator. This appears to work in at least
7.3 for a trivial example.
