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

Thank you all for your support.

2013/11/15 3:40、Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> のメッセージ:

>> On Thu, Nov 14, 2013 at 7:13 AM, Dang Minh Huong <kakalot49(at)gmail(dot)com> wrote:
>> 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;
>> ------
>
> You can easily make different tricks with records using the hstore
> module [1]. Just like this:
>
> [local]:5432 grayhemp(at)grayhemp=# \d a
> Table "public.a"
> Column | Type | Modifiers
> --------+---------+-----------
> id | integer | not null
> n | name |
>
> [local]:5432 grayhemp(at)grayhemp=# do $$
> declare rec a[];
> begin
> rec[1] := (1, 'a')::a;
> rec[2] := (2, 'b')::a;
> rec[1] := rec[1] #= (hstore('id', 3::text) || hstore('n', null));
> raise info '% %', rec[1].id, rec[1].n;
> end $$;
> INFO: 3 <NULL>
> DO
>
> [1] http://www.postgresql.org/docs/9.3/static/hstore.html
>
Thanks, i will try it.

> --
> Kind regards,
> Sergey Konoplev
> PostgreSQL Consultant and DBA
>
> http://www.linkedin.com/in/grayhemp
> +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
> gray(dot)ru(at)gmail(dot)com

Thanks,
Huong,