Selects with Array member

From: Nathan Heagy <nathan(at)frontlogic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Selects with Array member
Date: 2001-01-19 15:46:50
Message-ID: Pine.LNX.4.21.0101190944540.1908-100000@shell.frontlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to know how to select based on a value's membership in an array. I
have tried something like

select * from this_table where this_list *= 'a';

which I found after many obscure searches on google. However pgsql doesn't
know what to do with this operator. Any idea or advice are greatly
appreciated.

Nathan Heagy

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Front Logic . Vividworks . Cow Comics . Thirty-Nine Days

Browse pgsql-general by date

  From Date Subject
Next Message Joel Bernstein 2001-01-19 15:49:44 Re: Why does the JDBC driver not support prepareCall?
Previous Message Culley Harrelson 2001-01-19 15:43:12 Re: couple of general questions