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

From: Dang Minh Huong <kakalot49(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Equivalent syntax of PL/SQL using array in PL/pgSQL
Date: 2013-11-14 15:13:31
Message-ID: 60033AA3-05A1-4394-8FEC-D1C3DCDDF74F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elliot 2013-11-14 15:20:31 Re: Equivalent syntax of PL/SQL using array in PL/pgSQL
Previous Message Alexander Farber 2013-11-14 15:09:52 Re: Tuning 9.3 for 32 GB RAM