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 synt
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