Re: [GENERAL] How to search for composite type array

2012-10-02 Thread ChoonSoo Park
, 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

Re: [GENERAL] How to search for composite type array

2012-10-01 Thread David Johnston
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

[GENERAL] How to search for composite type array

2012-10-01 Thread ChoonSoo Park
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