Re: proof concept: do statement parametrization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proof concept: do statement parametrization
Date
Msg-id 3398.1278251884@sss.pgh.pa.us
Whole thread Raw
In response to Re: proof concept: do statement parametrization  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proof concept: do statement parametrization
Re: proof concept: do statement parametrization
Re: proof concept: do statement parametrization
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> my syntax is reflecting fact, so these are not true parameters - it's
> +/- similar to default values of function parameters.

FWIW, that doesn't seem like a positive to me.

> You cannot to
> write do (a int := $1) $$ ... $$ - because utils statements hasn't
> have variables.

Yet.  I don't particularly want to relax that either, but the syntax of
this feature shouldn't assume it'll be true forever.

I think it's better to not confuse these things with default parameters,
so Florian's idea looks better to me.

BTW, we intentionally didn't put any provision for parameters into DO
originally.  What's changed to alter that decision?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pessimal trivial-update performance
Next
From: "Andrew Dunstan"
Date:
Subject: Re: proof concept: do statement parametrization