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: | Raw Message | Whole Thread | 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 ? |