Frankly put, i didn't know that this perspective exists and then thanks for putting it that way then !!
Guess I should take a relook at how I plan to use those VIEWS.
Thanks
Robins
A rule of thumb is that ORDER BY in a view is bad design, IMHO.
regards, tom lane