, October 01, 2012 5:50 PM
> *To:* pgsql-general@postgresql.org
> *Subject:* [GENERAL] How to search for composite type array
>
> ** **
>
> Hello postgresql gurus,
>
> ** **
>
> I want to have an array of composite type in a table. Retrieving/saving
> value
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ChoonSoo Park
Sent: Monday, October 01, 2012 5:50 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to search for composite type array
Hello postgresql gurus,
I want to have an array
Hello postgresql gurus,
I want to have an array of composite type in a table. Retrieving/saving
value work fine.
I just wonder how I can search against composite type array.
CREATE TYPE CompXYZ AS (
attr1 integer,
attr2 text,
attr3 inet
);
CREA