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

From Dang Minh Huong
Subject Re: Equivalent syntax of PL/SQL using array in PL/pgSQL
Date
Msg-id 38896F17-30F1-48D8-B82B-386A0E5EAE99@gmail.com
Whole thread Raw
In response to Re: Equivalent syntax of PL/SQL using array in PL/pgSQL  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Hi,

2013/11/15 0:43、David Johnston <polobo@yahoo.com> のメッセージ:

> bocap wrote
>>>> (rec[1]).t1 := 1;
>
> You need to stay one-level higher and re-build the entire typ entry then
> assign it back to the array at the same position.
>
> rec[1] = (1, rec[1].t2)::typ;
>

Thanks. I think, i can solve it with this way.

> David J.
>
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Equivalent-syntax-of-PL-SQL-using-array-in-PL-pgSQL-tp5778355p5778364.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Regards,
Huong,

pgsql-general by date:

Previous
From: Dang Minh Huong
Date:
Subject: Re: Equivalent syntax of PL/SQL using array in PL/pgSQL
Next
From: Elliot
Date:
Subject: Re: Equivalent syntax of PL/SQL using array in PL/pgSQL