Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
> In a PL/PgSQL function I have the following:
> ----
> execute $l2$
> alter table $l2$||ct||$l2$ add check(
> data>=$1::timestamp and data<$2::timestamp and maga=$3 )
> $l2$ using rec.d0,rec.d1,rec.maga;
> ----
> which yields to this error messsge:
> ERROR: there is no parameter $1
You can't use a parameter of the function in a CHECK constraint on a
table. The CHECK constraint is permanent and can't refer to transient
state like that.
regards, tom lane