The thing is, this is the wrong thing to do. The relational model makes it
easy to define 'lists' or 'sets.' Table 2 should have:
table2
Name group
joe group1
mark group2
joe group3
linda group3
The table is now just what you want: it shows the groups each person is a
member of. So:
SELECT name, group FROM table2 ORDER BY name;
Will
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Aggarwal , Ajay
> Sent: Thursday, November 02, 2000 5:32 PM
> To: 'pgsql-general@postgresql.org'
> Subject: [GENERAL] question on SELECT using LIKE
>
>
> Please respond to ajay@crossbeamsys.com since I don't subscribe to the
> mailing list.
>
> I have 2 tables :
>
> Table1
> Name Age
> joe 23
> mark 25
> linda 22
>
> Table2
> NameList Group
> joe group1
> mark group2
> joe linda group3
>
> For each person in Table1, I want to list the groups that he/she
> is a member
> of. Table2 has the group membership information, but notice that
> the first
> column of Table2 is a list of names rather than a single name.
>
> I want to be able to use the the following SELECT call :
>
> SELECT t1.name, t2.group
> FROM table1 t1, table2 t2
> WHERE t2.namelist LIKE %t1.name%;
>
> But its not working. The problem is in '%t1.name%', the second operand of
> LIKE.
>
> Thanks in advance. Please Cc your reply to ajay@crossbeamsys.com as well.
>
> Ajay
>
