Anonymous code block with parameters
От
Kalyanov Dmitry
Тема
Anonymous code block with parameters
Дата
Msg-id
1410849538.4296.19.camel@localhost
Список
Дерево обсуждения
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>
I'd like to propose support for IN and OUT parameters in 'DO' blocks.
Currently, anonymous code blocks (DO statements) can not receive or
return parameters.
I suggest:
1) Add a new clause to DO statement for specifying names, types,
directions and values of parameters:
DO [LANGUAGE ] [USING ()]
where has the same syntax as in
'CREATE FUNCTION ()'.
Example:
do $$ begin z := x || y; end; $$
language plpgsql
using
( x text = '1', in out y int4 = 123, out z text
);
2) Values for IN and IN OUT parameters are specified using syntax for
default values of function arguments.
3) If DO statement has at least one of OUT or IN OUT parameters then it
returns one tuple containing values of OUT and IN OUT parameters.
Do you think that this feature would be useful? I have a
proof-of-concept patch in progress that I intend to publish soon.
В списке pgsql-hackers по дате отправления