| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to get normalized data from tekst column |
| Date: | 2011-11-24 13:47:12 |
| Message-ID: | 789B5CE2344148B29E5E0DF29C0F3DCD@dell2 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Project table contains salesman names and percents as shown
below. Single comment column contains 1-2 salesman names and commissions.
How select normalized data from this table ?
Andrus.
CREATE TABLE project (
id char(10) primary key,
comment char(254)
);
insert into test values ('2010-12', 'Aavo 19%, Peedu 15%');
insert into test values ('2010-22', 'Lauri-21%,Peedu 15%');
insert into test values ('2011-33', 'Taavi 21%');
How to create select statement in Postgresql 8.1.23 which
selects this data as normalized table like
CREATE TABLE commission (
projectid char(10),
salesman char(5),
commission n(2) )
result using data above should be
'2010-12', 'Aavo', 19
'2010-12', 'Peedu', 15
'2010-22', 'Lauri', 21
'2010-22', 'Peedu', 15
'2011-33', 'Taavi', 21
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaëtan Allart | 2011-11-24 13:51:07 | General performance/load issue |
| Previous Message | pasman pasmański | 2011-11-24 13:37:11 | How to display the progress of query |