[GENERAL] Selects with Array member

2001-01-19 Thread Nathan Heagy
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 appre

[GENERAL] Selects with Array member

2001-01-19 Thread Nathan Heagy
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 appre