Skip site navigation (1) Skip section navigation (2)

Re: [PL/PgSQL] EXECUTE...USING enhancement proposal

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Date: 2010-01-15 08:57:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
2010/1/15 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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

In response to


pgsql-hackers by date

Next:From: Pavel StehuleDate: 2010-01-15 09:00:57
Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Previous:From: Pavel StehuleDate: 2010-01-15 08:52:17
Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group