[GENERAL] upgrade 8.1.4 - latest, sort order subquery

2007-06-26 Thread jef peeraer
i decide this weekend to upgrade to the latest stable version from an 8.1.4 . Upgrade went smootly, as usual, but today, i've got some phonecalls of something weird. The query is as follows : registratie=# select * from module_info where type_module_id = 1; naam | korte_beschrijving |

Re: [GENERAL] upgrade 8.1.4 - latest, sort order subquery

2007-06-26 Thread Richard Huxton
jef peeraer wrote: i decide this weekend to upgrade to the latest stable version from an 8.1.4 . Upgrade went smootly, as usual, but today, i've got some phonecalls of something weird. The query is as follows : registratie=# select * from module_info where type_module_id = 1; i combine this

Re: [GENERAL] upgrade 8.1.4 - latest, sort order subquery

2007-06-26 Thread Michael Glaesemann
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

Re: [GENERAL] upgrade 8.1.4 - latest, sort order subquery

2007-06-26 Thread Tom Lane
Richard Huxton [EMAIL PROTECTED] writes: jef peeraer wrote: registratie=# select * from module_info where type_module_id in (select * from get_parent_type_modules(1)); The order is completely ignored, although there is an order by in the view 'module_info' You're applying a where clause to