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:55:53
Message-ID: Pine.LNX.4.21.0101190955290.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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith G. Murphy 2001-01-19 16:13:53 Re: Re: MS Access data to PostgrSQL data
Previous Message Peter Eisentraut 2001-01-19 15:55:31 Re: Questions about Synonyms - Again