Equivalent syntax of PL/SQL using array in PL/pgSQL - Mailing list pgsql-general

From Dang Minh Huong
Subject Equivalent syntax of PL/SQL using array in PL/pgSQL
Date
Msg-id 60033AA3-05A1-4394-8FEC-D1C3DCDDF74F@gmail.com
Whole thread Raw
Responses Re: Equivalent syntax of PL/SQL using array in PL/pgSQL
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL
List pgsql-general
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,

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Tuning 9.3 for 32 GB RAM
Next
From: Elliot
Date:
Subject: Re: Equivalent syntax of PL/SQL using array in PL/pgSQL