Re: patch: inline code with params - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch: inline code with params
Date
Msg-id CAFj8pRC0R5e5-R4uYWCNcvaVpTYzQ05HJEbcRmVBjRjRDD5LVg@mail.gmail.com
Whole thread Raw
In response to patch: inline code with params  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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.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.

Attachment

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Bug tracker tool we need
Next
From: Satoshi Nagayasu
Date:
Subject: New statistics for WAL buffer dirty writes