Re: Anonymous code block with parameters

Поиск
Список
Период
Сортировка
Искать
От
Josh Berkus
Тема
Re: Anonymous code block with parameters
Дата
Msg-id
541B3F43.9020906@agliodbs.com
Список
Дерево обсуждения
Anonymous code block with parameters Kalyanov Dmitry <kalyanov.dmitry@gmail.com>
Re: Anonymous code block with parameters Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Anonymous code block with parameters Andres Freund <andres@2ndquadrant.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Hannu Krosing <hannu@2ndQuadrant.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Hannu Krosing <hannu@2ndQuadrant.com>
Re: Anonymous code block with parameters Craig Ringer <craig@2ndquadrant.com>
Re: Anonymous code block with parameters Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Anonymous code block with parameters Vik Fearing <vik.fearing@dalibo.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Martijn van Oosterhout <kleptog@svana.org>
Re: Anonymous code block with parameters Marko Tiikkaja <marko@joh.to>
Re: Anonymous code block with parameters Andres Freund <andres@2ndquadrant.com>
Re: Anonymous code block with parameters Andrew Dunstan <andrew@dunslane.net>
Re: Anonymous code block with parameters Hannu Krosing <hannu@2ndQuadrant.com>
Re: Anonymous code block with parameters Peter Eisentraut <peter_e@gmx.net>
Re: Anonymous code block with parameters Andres Freund <andres@2ndquadrant.com>
Re: Anonymous code block with parameters Merlin Moncure <mmoncure@gmail.com>
Re: Anonymous code block with parameters Petr Jelinek <petr@2ndquadrant.com>
Re: Anonymous code block with parameters Craig Ringer <craig@2ndquadrant.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Andres Freund <andres@2ndquadrant.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Andres Freund <andres@2ndquadrant.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Hannu Krosing <hannu@2ndQuadrant.com>
Re: Anonymous code block with parameters Vik Fearing <vik.fearing@dalibo.com>
Re: Anonymous code block with parameters Marko Tiikkaja <marko@joh.to>
Re: Anonymous code block with parameters Hannu Krosing <hannu@krosing.net>
Re: Anonymous code block with parameters Hannu Krosing <hannu@2ndQuadrant.com>
Re: Anonymous code block with parameters Merlin Moncure <mmoncure@gmail.com>
Re: Anonymous code block with parameters Merlin Moncure <mmoncure@gmail.com>
Re: Anonymous code block with parameters Marko Tiikkaja <marko@joh.to>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
Re: Anonymous code block with parameters Pavel Stehule <pavel.stehule@gmail.com>
On 09/18/2014 01:10 PM, Hannu Krosing wrote:
> One possible syntax would be extending WITH to somehow enable on-spot
> functions in addition to on-spot views
> 
> WITH FUNCTION myfunc(...) RETURNS TABLE(...) LANGUAGE plpgsql AS $$
> ...
> $$
> SELECT f.*
>   FROM myfunc(x,y,z);

Oh!  Awesome!

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


В списке pgsql-hackers по дате отправления
От: Hannu Krosing
Дата:
От: Vik Fearing
Дата:
FAQ