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 | kolom_naam | xul_opties |
type_veld_id | lengte | is_verplicht | type_module_id
--------+--------------------+---------------+-----------------+--------------+--------+--------------+----------------
alg_02 | naam | naam | |
3 | 0 | f | 1
alg_03 | voornaam | voornamen | |
3 | 0 | f | 1
alg_01 | anoniem | anoniem | |
2 | 0 | f | 1
cl_01 | geslacht | geslacht | |
1 | 0 | t | 1
cl_19 | geboortedatum | geboortedatum | hide_clock,true |
7 | 0 | f | 1
cl_02 | leeftijd | leeftijd | |
1 | 0 | t | 1
cl_15 | origine | origine | |
1 | 0 | f | 1
(7 rows)
i combine this with the next query in a subquery
registratie=# select * from get_parent_type_modules(1);
NOTICE: first query
get_parent_type_modules
-------------------------
1
(1 row)
The resulting query , which should return the same result as the first one
registratie=# select * from module_info where type_module_id in
(select * from get_parent_type_modules(1));
NOTICE: first query
naam | korte_beschrijving | kolom_naam | xul_opties |
type_veld_id | lengte | is_verplicht | type_module_id
--------+--------------------+---------------+-----------------+--------------+--------+--------------+----------------
cl_15 | origine | origine | |
1 | 0 | f | 1
cl_02 | leeftijd | leeftijd | |
1 | 0 | t | 1
cl_19 | geboortedatum | geboortedatum | hide_clock,true |
7 | 0 | f | 1
cl_01 | geslacht | geslacht | |
1 | 0 | t | 1
alg_01 | anoniem | anoniem | |
2 | 0 | f | 1
alg_03 | voornaam | voornamen | |
3 | 0 | f | 1
alg_02 | naam | naam | |
3 | 0 | f | 1
(7 rows)
The order is completely ignored, although there is an order by in the view
'module_info'
jef peeraer
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
