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 |
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
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
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