Re: Equivalent syntax of PL/SQL using array in PL/pgSQL

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]?