Re: upgrade 8.1.4 -> latest, sort order subquery

On Jun 26, 2007, at 14:52 , jef peeraer wrote:

> The order is completely ignored, although there is an order by in  
> the view
> 'module_info'

I don't know what has caused the change in your system, but IIRC, the  
spec does not require a view to return rows in any particular order— 
I'm not even sure the spec allows ORDER BY in a view definition.  
(Whether or not PostgreSQL follows the spec in this case is another  
matter—I don't believe it does. So there's probably something a  
little more interesting going on here that others might help you with.)

A quick, spec-compliant fix would be to add an ORDER BY clause in the  
calling query.

Other than the row order, the results look correct, or am I missing  
something?

You might also look into using a set returning function, in which you  
can specify the order of the results.

Michael Glaesemann
grzm seespotcode net