pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion about arrays
3+ messages / 2 participants
[nested] [flat]
* Question about arrays
@ 1999-08-09 18:18 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 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
* Re: [SQL] Question about arrays
@ 1999-08-10 15:16 David Ouellet <David.Ouellet@drev.dnd.ca>
parent: 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
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