upgrade 8.1.4 -> latest, sort order subquery
От | jef peeraer |
---|---|
Тема | upgrade 8.1.4 -> latest, sort order subquery |
Дата | |
Msg-id | 46816E62.5040408@telenet.be обсуждение исходный текст |
Ответы |
Re: upgrade 8.1.4 -> latest, sort order subquery
Re: upgrade 8.1.4 -> latest, sort order subquery |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: