On Jul4, 2010, at 08:41 , Pavel Stehule wrote:
> I enhanced DO statement syntax to allowing a parameters. Syntax is
> relative simple:
> 
> do ([varname] vartype := value, ...) $$ ... $$


I think it'd be more useful to put the values at the very end of the statement, not somewhere in the middle. For positional parameters I envision

do (vartype, ...) $$ ... $$ using value, ...

and for named parameters it'd be

do (varname vartype) $$ ... $$ using varname := value, ...

I won't make a difference for your use-case, but it'd make it easier to call the same DO block with different parameters, like in the following shell  snippet.

COMMANDS="DO (arg int) $$ ... $$"
(for a in arg1, arg2, arg3, arg4; do
  echo "$COMMANDS USING $a;"
done) | psql 

best regards,
Florian Pflug

In response to

• proof concept: do statement parametrization at 2010-07-04 06:41:35 from Pavel Stehule

Responses

• Re: proof concept: do statement parametrization at 2010-07-04 09:59:36 from Pavel Stehule

pgsql-hackers by date

Next:	From: Pavel Stehule	Date: 2010-07-04 09:59:36
	Subject: Re: proof concept: do statement parametrization
Previous:	From: Rainer Pruy	Date: 2010-07-04 07:40:06
	Subject: Re: pessimal trivial-update performance