Ok, it is clear now: better is never to use the ORDER BY clause in a view,
that avoid problems.

Every day I learn something new.

Greetings.

Walter.

On Fri, Mar 1, 2013 at 12:39 PM, Mark Rotteveel <mark@...>wrote:

> **
>
>
> > I guess that the use of ORDER BY applied on VIEWS is ok.
> >
> > eg. SELECT * from vVIEW ORDER BY VIEW.FIELD1
>
> You shouldn't see this as applying an order by to a view, but as applying
> an order by to (the result of) a query. That query just happens to only
> reference a view.
>
> Mark
>
>
>


[Non-text portions of this message have been removed]