On Mar 19, 2011, at 9:50 PM, Stefan Keller wrote:
> Unfortunately it still does'nt work. I get
>
> ERROR: wrong record constant: »('a'«
> LINE 2: 5, $${ ('a', 'aa'), ('b', 'bb') }$$ );
> ^
> DETAIL: Unexpected end of line.
Try following, it should work:
INSERT INTO mytypetable VALUES ( 6,ARRAY[row('a', 'aa'), row('b', 'bb')]::mytype[] );
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com