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

Hi,

2013/11/15 0:20、Elliot <yields.falsehood@gmail.com> のメッセージ:

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

Sorry for this miss.
Yes, typ is the type and rec is the variable.
I only want to assign a value to rec[1].t1.

Thanks,
Huong,