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

2010/9/4 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>