Re: [PL/PgSQL] EXECUTE...USING enhancement proposal - Mailing list pgsql-hackers

From Vincenzo Romano
Subject Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Date
Msg-id 3eff28921001150057t4f0cd5b4nb89109d90b062c8@mail.gmail.com
Whole thread Raw
In response to Re: [PL/PgSQL] EXECUTE...USING enhancement proposal  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [PL/PgSQL] EXECUTE...USING enhancement proposal  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
2010/1/15 Pavel Stehule <pavel.stehule@gmail.com>:
> I disagree with this functionality for USING clause. Main parser
> doesn't support some enhanced syntax. But we can discus about some
> function 'printf' or 'format' that can help with similar task.
>
> some like
>
> EXECUTE format('ALTER TABLE % ADD CHECK (col1=% AND col2=%)',
>                              quote_ident(tablename), cval1, cval2, cval3);
>
>
> there was two proposals:
> a) based on syntax our RAISE statements
> b) based on printf syntax
>
> Personally prefer a) - it is simpler and enough
>
> Pavel



I do like the printf-like approach more than my proposal!
Do you think about a built-in implementation rather than the on in PLGSQL?

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Next
From: Pavel Stehule
Date:
Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal