From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Florian Pflug <fgp(at)phlo(dot)org> |
Subject: | Re: patch: inline code with params |
Date: | 2012-07-07 11:16:49 |
Message-ID: | CAFj8pRC0R5e5-R4uYWCNcvaVpTYzQ05HJEbcRmVBjRjRDD5LVg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(dot)stehule(at)gmail(dot)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.
Attachment | Content-Type | Size |
---|---|---|
inline_code_with_params2.patch | application/octet-stream | 18.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Satoshi Nagayasu | 2012-07-07 12:00:51 | New statistics for WAL buffer dirty writes |
Previous Message | Magnus Hagander | 2012-07-07 10:59:02 | Re: Bug tracker tool we need |