multiple column to onec column

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.

Responses

Browse pgsql-general by date

  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 ?