Thread: Selects with Array member

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

On Fri, Jan 19, 2001 at 09:55:53AM -0600, Nathan Heagy wrote:

You need the array functions included in the contrib directory of the source code...
I don't know why it isn't part of the standard distribution.
Bye

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

> You need the array functions included in the contrib directory of the source code...
> I don't know why it isn't part of the standard distribution.

Ok, here is a question that should maybe go to novice as well. I'm not the
admin for the db, but he's gone until Monday so I'll need to set this up
myself. I have compiled the array module and put it in the
pgsql/lib/modules/ directory. Now how do I get pgsql to load this module
automatically?

Thanks,

   Nathan Heagy



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

On Fri, Jan 19, 2001 at 11:11:33AM -0600, Nathan Heagy wrote:
> Ok, here is a question that should maybe go to novice as well. I'm not the
> admin for the db, but he's gone until Monday so I'll need to set this up
> myself. I have compiled the array module and put it in the
> pgsql/lib/modules/ directory. Now how do I get pgsql to load this module
> automatically?

I think it's written in the README, but I'm quite sure that you need privileges
on the database (not on the whole postgres) to activate it. Otherwise I don't know how to proceed.

bye