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.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
