Re: can we enhance regtype infunction to support %type and %type[]

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: can we enhance regtype infunction to support %type and %type[]
Дата
Msg-id AANLkTi=sHkNaH7_tnc_qfcc8qc732JLjA9Ez_-MZAHNm@mail.gmail.com
обсуждение исходный текст
Ответ на Re: can we enhance regtype infunction to support %type and %type[]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/9/4 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g.
>> tab.col%TYPE[]
>
>> Some the most simple solution can be enhancing regtype to support this
>> syntax
>
> I'm not really in favor of adding a wart like that to regtype, and
> I don't see how it would do anything to advance the TODO item anyway.

it can reduce a duplicate code - it is used on PL level and on PLpgSQL.

and be very useful as protection to SQL injection, where you have to
check if some table has some column.

Regards

Pavel Stehule


>
>                        regards, tom lane
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: git: uh-oh
Следующее
От: Peter Eisentraut
Дата:
Сообщение: 9.1alpha1 bundled -- please verify