Order by not possible in view?

[Ruslan Zasukhin]

On 20/7/07 11:24 AM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:

Hi Danny,

> Hi Ruslan & list,
> 
> this SQL-statement
> 
> CREATE OR REPLACE VIEW vw_connections AS (SELECT ** FROM
> tbl_connection ORDER BY bookmark_name)

Btw, note  OR REPLACE  -- is optional


----------------------------
> 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...

If I am not mistaken this is by SQL Standard.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]