Re: [HACKERS] patch: inline code with params

2012-07-07 Thread Pavel Stehule
Hello updated patch - parameters can be subqueries now. This needs enhancing SPI little bit. postgres=# do (a int, b int, text) $$begin raise notice '% % %', $1, $2, $3; end; $$ language plpgsql using 10+100,(select a from x), :'USER'; NOTICE: 110 10 pavel DO Regards Pavel 2012/7/6 Pavel Ste

[HACKERS] patch: inline code with params

2012-07-06 Thread Pavel Stehule
Hello I updated my two years old patch http://archives.postgresql.org/pgsql-hackers/2010-07/txtIakTCBA15Z.txt Syntax is based on Florian Pflog's proposal http://archives.postgresql.org/pgsql-hackers/2010-07/msg00110.php postgres=# do (a int, b int, text) $$begin raise notice '% % %', $1, $2, $3;