Postgres Pro
Downloads
Home   >   mailing lists

Populating array of composite datatype - Mailing list pgsql-general

From Sameer Thakur
Subject Populating array of composite datatype
Date
Msg-id CABzZFEsyJTghjqkuXGKs904qGt6cSkWhE_cHvrWhZMFLeH2M8Q@mail.gmail.com
Whole thread Raw
Responses Re: Populating array of composite datatype  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Re: Populating array of composite datatype  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Hierarchical numeric data type
Next
From: BladeOfLight16
Date:
Subject: Re: Staging Database