From: | "Giovanni Serrato Castillo" <gserrato(at)sager(dot)telecom-co(dot)net> |
---|---|
To: | "Aggarwal , Ajay" <ajay(at)crossbeamsys(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: question on SELECT using LIKE |
Date: | 2000-11-05 15:45:10 |
Message-ID: | 033201c0473f$6162cab0$451c15c8@telecomco.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Prueba lo siguiente:
SELECT t1.name, t2.group
FROM table1 t1, table2 t2
WHERE t2.namelist LIKE '%' || to_char(t1.name) || '%';
----- Original Message -----
From: "Aggarwal , Ajay" <ajay(at)crossbeamsys(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, November 02, 2000 5:32 PM
Subject: [GENERAL] question on SELECT using LIKE
> Please respond to ajay(at)crossbeamsys(dot)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(at)crossbeamsys(dot)com as well.
>
> Ajay
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2000-11-05 16:12:38 | Referential integrity question |
Previous Message | Albert REINER | 2000-11-05 15:18:36 | Re: Help needed with pg.pm to connect to postgresql |