Volatile functions in subqueries don't prevent subqueries from being evaluated in initplans?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Volatile functions in subqueries don't prevent subqueries from being evaluated in initplans?
Дата
Msg-id 87zln74wbg.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответы Re: Volatile functions in subqueries don't prevent subqueries from being evaluated in initplans?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hm, shouldn't this query notice that random() is volatile and not make the
subquery an initplan?


postgres=#  select i, (select (random()*1000)::integer  ) from x limit 5;i | ?column? 
---+----------1 |      6772 |      6773 |      6774 |      6775 |      677
(5 rows)

postgres=# explain  select i, (select (random()*1000)::integer  ) from x limit 5;                       QUERY PLAN
                  
 
-----------------------------------------------------------Limit  (cost=0.02..0.11 rows=5 width=4)  InitPlan    ->
Result (cost=0.00..0.02 rows=1 width=0)  ->  Seq Scan on x  (cost=0.00..64.80 rows=3480 width=4)
 
(4 rows)


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Asko Oja"
Дата:
Сообщение: Re: Patch: plan invalidation vs stored procedures
Следующее
От: Alvaro Herrera
Дата:
Сообщение: make dist does not work in VPATH