[GENERAL] Tablename.columnname%TYPE in Types On PostgreSQL 9.2

[Adrien Besson]

Hello Everyone,

Trying to create a type using %Type seems not to work on PostgreSQL 9.2:

 CREATE TYPE type1 AS (tvar_1 TABLE1. COL1%TYPE , tvar_2 INTEGER);

Returns

XX ERROR:  syntax error at or near "%"

Where am I wrong ? Someone has an idea ?

Thanks a lot !

BESSON Adrien