Re: Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs
Дата
Msg-id 54AC6C79.1020805@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs  (David Johnston <david.g.johnston@gmail.com>)
Список pgsql-hackers
On 1/6/15, 10:32 AM, Alvaro Herrera wrote:
> Tom Lane wrote:
>
>> What would make sense to me is to teach the planner about inlining
>> SQL functions that include ORDER BY clauses, so that the performance
>> issue of a double sort could be avoided entirely transparently to
>> the user.
>
> Wouldn't this be applicable to functions in other languages too, not
> only SQL?

Dumb question... we can inline functions from other languages? What chunk of code handles that?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Add min and max execute statement time in pg_stat_statement