Adriano dos Santos Fernandes:

> Vlad Horsun wrote:
>>> Why not use the the table column type?
>>> Oracle has this feature:
>>>
>>> Columname table.column%type;
>>>
>> I also like it. But without "%type" :) I.e.
>>
>> DECLARE <varname> TYPE OF <tablename>.<columnname>
>>
>> Adriano, what do you think ?
>>
> The functionality and the syntax looks great to me, if future schemas
> shares the same namespace as tables, to not have ambiguity.
>

Great, I also like it. We reanimate very useful GPRE's operator BASED ON
functionality. May be also use that syntax:

In epp file was:
BASED ON QLI$PROCEDURES.QLI$PROCEDURE_NAME padded_name;

In SQL may be:
DECLARE <varname> BASED ON <tablename>.<columnname>