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 <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly