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

2012-10-02 Thread ChoonSoo Park
Thank you David, unnest is the secret to this problem. I appreciate your help. -Choon Park On Mon, Oct 1, 2012 at 6:56 PM, David Johnston wrote: > *From:* pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] *On Behalf Of *ChoonSoo Park > *Sent:* Monday, October 01

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 o