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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Дата
Msg-id 162867791001150100q5221fa4aob594f98ca8fb4310@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PL/PgSQL] EXECUTE...USING enhancement proposal  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Список pgsql-hackers
2010/1/15 Vincenzo Romano <vincenzo.romano@notorand.it>:
> 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?
>

sure.

the plpgsql isn't problem in 8.5, but integrated version can be little
bit smarter.

Pavel


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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: [PL/PgSQL] EXECUTE...USING enhancement proposal
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Streaming replication, loose ends