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]? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
