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

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

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

Adrien Besson wrote: 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 ? I think that the %TYPE syntax is