pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question about arrays
3+ messages / 2 participants
[nested] [flat]

* Question about arrays
@ 1999-08-09 18:18 David Ouellet <David.Ouellet@drev.dnd.ca>
  1999-08-10 15:16 ` Re: [SQL] Question about arrays David Ouellet <David.Ouellet@drev.dnd.ca>
  0 siblings, 1 reply; 3+ messages in thread

From: David Ouellet @ 1999-08-09 18:18 UTC (permalink / raw)
  To: pgsql-sql

Hi,
Is there an operator to test if a value is contained into an array?

What I'm trying to do is create a function to check is a certain user
belongs to a certain group.
I want to check is the userid is contained in the pg_grouip.grolist
array.

How would I do that?

Thanks in advance
David Ouellet





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Question about arrays
  1999-08-09 18:18 Question about arrays David Ouellet <David.Ouellet@drev.dnd.ca>
@ 1999-08-10 15:16 ` David Ouellet <David.Ouellet@drev.dnd.ca>
  0 siblings, 0 replies; 3+ messages in thread

From: David Ouellet @ 1999-08-10 15:16 UTC (permalink / raw)
  To: pgsql-sql

Never mind, I found the answer.
For those interested, look at contrib/array it adds a whole bunch of
operators that iterates over an array.

David Ouellet

David Ouellet wrote:

> Hi,
> Is there an operator to test if a value is contained into an array?
>
> What I'm trying to do is create a function to check is a certain user
> belongs to a certain group.
> I want to check is the userid is contained in the pg_grouip.grolist
> array.
>
> How would I do that?
>
> Thanks in advance
> David Ouellet




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: [SQL] Question about arrays
@ 1999-08-09 20:25 Jackson, DeJuan <djackson@cpsgroup.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jackson, DeJuan @ 1999-08-09 20:25 UTC (permalink / raw)
  To: David Ouellet <David.Ouellet@drev.dnd.ca>; pgsql-sql

Check contrib/array in the distribution.

> -----Original Message-----
> From:	David Ouellet [SMTP:David.Ouellet@drev.dnd.ca]
> Sent:	Monday, August 09, 1999 1:19 PM
> To:	pgsql-sql@postgreSQL.org
> Subject:	[SQL] Question about arrays
> 
> Hi,
> Is there an operator to test if a value is contained into an array?
> 
> What I'm trying to do is create a function to check is a certain user
> belongs to a certain group.
> I want to check is the userid is contained in the pg_grouip.grolist
> array.
> 
> How would I do that?
> 
> Thanks in advance
> David Ouellet
> 
> 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-08-10 15:16 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-09 18:18 Question about arrays David Ouellet <David.Ouellet@drev.dnd.ca>
1999-08-10 15:16 ` David Ouellet <David.Ouellet@drev.dnd.ca>
1999-08-09 20:25 RE: [SQL] Question about arrays Jackson, DeJuan <djackson@cpsgroup.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox