Patch for cursor calling with named parameters
От
Yeb Havinga
Тема
Patch for cursor calling with named parameters
Дата
Msg-id
4E71B4C4.3010004@gmail.com
Список
Дерево обсуждения
Patch for cursor calling with named parameters Yeb Havinga <yebhavinga@gmail.com>
Re: Patch for cursor calling with named parameters Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Patch for cursor calling with named parameters Yeb Havinga <yebhavinga@gmail.com>
Hello list, The following patch implements cursor calling with named parameters in addition to the standard positional argument lists. c1 cursor (param1 int, param2 int) for select * from rc_test where a > param1 and b > param2; open c1($1, $2); -- this is currently possible open c1(param2 := $2, param1 := $1); -- this is the new feature Especially for cursors with a lot of arguments, this increases readability of code. This was discussed previously in http://archives.postgresql.org/pgsql-hackers/2010-09/msg01433.php. We actually made two patches: one with => and then one with := notation. Attached is the patch with := notation. Is it ok to add it to the next commitfest? regards, Yeb Havinga, Willem Dijkstra -- Yeb Havinga http://www.mgrid.net/ Mastering Medical Data
В списке pgsql-hackers по дате отправления