Populating array of composite datatype

From: Sameer Thakur <samthakur74(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Populating array of composite datatype
Date: 2013-08-07 10:34:01
Message-ID: CABzZFEsyJTghjqkuXGKs904qGt6cSkWhE_cHvrWhZMFLeH2M8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I have a composite datatype abc which has two integer fields x,y.
I have a table Test which has an array of abc.
I am trying to populate Test. Tried
insert into test values (ARRAY[abc(1,2)]); but got error
ERROR: function abc(integer, integer) does not exist

Is there anyway for doing this?

regards
Sameer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BladeOfLight16 2013-08-07 10:38:28 Re: Staging Database
Previous Message Chris Travers 2013-08-07 10:21:02 Re: Hierarchical numeric data type