Horton
Menu

Re: patch: inline code with params

Pavel Stehule <pavel.stehule@gmail.com>

View thread
From: Pavel Stehule <pavel.stehule@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: Dimitri Fontaine <dfontaine@hi-media.com>, Peter Eisentraut <peter_e@gmx.net>, Florian Pflug <fgp@phlo.org>
Date: 2012-07-07T11:16:49Z
Lists: pgsql-hackers

Attachments

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.