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

From Pavel Stehule
Subject Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Date
Msg-id 162867791001150036u4abf855egeaa6ef85422d5f1e@mail.gmail.com
Whole thread Raw
In response to Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
>
> 3. Then I need to add the TABLE-level CHECK condition in order to
> exploit the "constraint_exclusion = on":
>            execute $l2$
>              alter table $l2$||ct||$l2$
>                add check(  $l0$||co||$l0$ )
>            $l2$ using $l0$||va||$l0$;
>

I am sorry, I am out. Your code isn't much readable:

Minimally there isn't placeholder - some like $x

It is game for the most cryptografic code :).

You searching a functionality that isn't in pg now :(. Clause USING
doesn't work like macros or templates in C++

look on this page - maybe it could be useful for you
http://wiki.postgresql.org/wiki/Sprintf

Regards
Pavel

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Next
From: Vincenzo Romano
Date:
Subject: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour