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