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
>
