Re: Weird EXECUTE ... USING behaviour - Mailing list pgsql-general

Vincenzo Romano <vincenzo.romano@notorand.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