Hi all,
I am using PostgreSQL 9.1 and get a syntax error with the following PL/pgSQL clause.
Is there any equivalent syntax in PL/pgSQL to solve it.
------
rec typ[];
(typ[1]).t1 := 1;
------
typ is type which was created by command below.
Create type typ as(
t1 interger,
t2 text);
I am migrating data from Oracle to PostgreSQL and encounter this issue.
Thanks,
Huong,