Selects with Array member - Mailing list pgsql-general

From Nathan Heagy
Subject Selects with Array member
Date
Msg-id Pine.LNX.4.21.0101190955290.1908-100000@shell.frontlogic.com
Whole thread Raw
Responses Re: Selects with Array member  (Gianpaolo Racca <gianpaolo@preciso.net>)
List 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



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Questions about Synonyms - Again
Next
From: Nathan Heagy
Date:
Subject: Selects with Array member