2011/9/15 Yeb Havinga <yebhavi...@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?
I think it is, as you have provided a patch. There exist also a mecanism to order the parameters of 'EXECUTE ... USING ...' (it's using a cursor), can the current work benefit to EXECUTE USING to use named parameters ? > regards, > Yeb Havinga, Willem Dijkstra > > -- > Yeb Havinga > http://www.mgrid.net/ > Mastering Medical Data > > > > -- > Sent via pgsql-hackers mailing list (firstname.lastname@example.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > > -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers