Order by not possible in view?

[Danny Lewkin]

Hi Ruslan & list,

this SQL-statement

CREATE OR REPLACE VIEW vw_connections AS (SELECT ** FROM  
tbl_connection ORDER BY bookmark_name)

results in an error :

10:19:40: Error: line 1:73: expecting ')', found 'ORDER'
10:19:40: Error: Kernel error: 0x71000
10:19:40: Error: line 1:73: expecting ')', found 'ORDER'

Is 'ORDER BY' not possible in a view statement??
Is it possible, when it's not possible now, to make it possible in  
the future? ;-)
Then I will be happy to put a feature request into mantis...

Greetz,

Danny