Thread

1. patch: inline code with params

   Pavel Stehule <pavel.stehule@gmail.com> — 2012-07-06T20:01:02Z

   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; end; $$ language plpgsql using 10+100,20, :'USER';
   NOTICE:  110 20 pavel
   DO
   
   This patch is not final - missing documentation, regress tests, and
   doesn't support subselects as expr.
   

2. Re: patch: inline code with params

   Pavel Stehule <pavel.stehule@gmail.com> — 2012-07-07T11:16:49Z

   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 Stehule <pavel.stehule@gmail.com>:
   > 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; end; $$ language plpgsql using 10+100,20, :'USER';
   > NOTICE:  110 20 pavel
   > DO
   >
   > This patch is not final - missing documentation, regress tests, and
   > doesn't support subselects as expr.