| From: | zab08 <zab08(at)126(dot)com> | 
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> | 
| Subject: | multiple column to onec column | 
| Date: | 2011-02-22 08:51:45 | 
| Message-ID: | 24878a22.164ae.12e4c912b70.Coremail.zab08@126.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
I have two table:
CREATE TABLE roles(role_name varchar(255) primary key);
CREATE TABLE roles_permissions(permission varchar(100), role_name varchar(100));
here is result by :
 SELECT * from roles;
 role_name 
-----------
 role1
 role2
(2 rows)
here is result by :
SELECT * from roles_permissions ;
 role_name | permission  
-----------+-------------
 role1     | permission1
 role1     | permission2
 role2     | permission1
(3 rows)
---------------------------------------------------------------------------
after the command:
SELECT * from roles, roles_permissions;
 role_name | role_name | permission  
-----------+-----------+-------------
 role1     | role1     | permission1
 role1     | role1     | permission2
 role1     | role2     | permission1
 role2     | role1     | permission1
 role2     | role1     | permission2
 role2     | role2     | permission1
the expected result is:
 role_name | permission  
-----------+-------------
 role1      | permission1,permission2,
 role2      | permission1
for short:
afer join of two table, here is some repeat columns,
I only want to a row for role1.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adarsh Sharma | 2011-02-22 09:21:01 | Mysql to Postgresql | 
| Previous Message | Dmitriy Igrishin | 2011-02-22 08:27:18 | Re: why is there no TRIGGER ON SELECT ? |