From: Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni@kymi.com>
Reply-To: aarni@kymi.com
Organization: KYMI.com
Subject: Querying a list field against another list
Date: Fri, 26 Nov 2004 16:17:57 +0200
User-Agent: KMail/1.6.2
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200411261617.57381.aarni@kymi.com>

Hi,

I tried to mail this to the novice list I believe it was rejected:

>>
The original message was received at 2004-11-26 14:55:09 +0100
from postoffice.local [10.0.0.1]

=A0 =A0----- The following addresses had permanent fatal errors -----
<jens@headlong.se>

=A0 =A0-----Transcript of session follows -----
=2E.. while talking to postoffice.local.:
>>> RCPT To:<jens@headlong.se>
<<< 550 5.1.1 unknown or illegal alias: jens@headlong.se
550 <jens@headlong.se>... User unknown
>>

So here's my question.

Hi people,

This is not quite a pg question, but any suggestions are most welcome.

How can one query a list of values against a db field that contains a list =
of
values ?


Table foo

foo_id | foo_name | da_list
=2D-------------------------------------
1 | x | 1,2,3,4,5
2 | y | 1,4,5
3 | z | 4,5,11
4 | xyz | 14,15,33

As a result from another query I have parameter bar =3D '1,4' and want to f=
ind
all rows from foo where da_list contains '1' or '4'. So loop over bar to lo=
op
over da_list in foo ?

My humble thanks,

Aarni

=2D-------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
=2D-------------