Обсуждение: Tablename.columnname%TYPE in Types On PostgreSQL 9.2

Поиск
Список
Период
Сортировка

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

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

От
Albe Laurenz
Дата:
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 PL/pgSQL only.

Yours,
Laurenz Albe