postgres 15 show error apply in this manner error email users.email%TYPE
CREATE TYPE userx AS (
email users.email%type,
name user.name%type,
area users.profession%type);
in tried replicated for oracle syntax
Type tipo_r IS RECORD (id number(3),
nombre varchar(10),
salario emp.salary%type);