From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Weird EXECUTE ... USING behaviour |
Date: | 2010-01-12 14:24:13 |
Message-ID: | 3eff28921001120624k47d00898p6d6df9bac95a7902@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/1/12 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> 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
>
Tom, $1, $2 and $3 should be the substitution arguments from the USING
predicate, not the function argument list, which in my case is an
empty list!
And the EXECUTE shoud implement a static binding with the "variables"
from the USING predicate ...
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Levchenko | 2010-01-12 14:26:18 | Re: need help with query, how to fold select result to array? |
Previous Message | Tom Lane | 2010-01-12 14:13:44 | Re: Weird EXECUTE ... USING behaviour |