On 2013-11-14 10:13, Dang Minh Huong wrote:
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,
If typ is the type and rec is the variable, do you mean to access rec[1]?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general