RE: question on SELECT using LIKE

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
>