2010/1/15 Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>:
> 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
> 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?
the plpgsql isn't problem in 8.5, but integrated version can be little
> Vincenzo Romano
> NotOrAnd Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2010-01-15 09:19:18|
|Subject: Streaming replication, loose ends|
|Previous:||From: Vincenzo Romano||Date: 2010-01-15 08:57:09|
|Subject: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal|