From: | Dang Minh Huong <kakalot49(at)gmail(dot)com> |
---|---|
To: | Elliot <yields(dot)falsehood(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Equivalent syntax of PL/SQL using array in PL/pgSQL |
Date: | 2013-11-14 15:32:41 |
Message-ID: | 14658D6A-801D-4C60-933D-96798A8B5C94@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
2013/11/15 0:20、Elliot <yields(dot)falsehood(at)gmail(dot)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,
From | Date | Subject | |
---|---|---|---|
Next Message | Elliot | 2013-11-14 15:38:35 | Re: Equivalent syntax of PL/SQL using array in PL/pgSQL |
Previous Message | Elliot | 2013-11-14 15:20:31 | Re: Equivalent syntax of PL/SQL using array in PL/pgSQL |