Combine, Merge, Concatenate

From: Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Combine, Merge, Concatenate
Date: 2006-01-23 11:06:22
Message-ID: 1138014382.12975.11.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear pgsql users,

I have a problem, which is quite hard to solve it in Perl (for me, of
course). I have to tables, which looks like

First Table:

1|001|002|003
2|006|04|002

Second Table:

001|text1|text2|text3
002|text6|text1|text2

Now I would like to concatenate this two tables into new table:

Third Table:

1|text1|text2|text3|text6 *
2|etc

*Notes; key=1 from first table; substitute 001 from first table with
text1|text2|text3 and 002 with text6 etc...

Is that possible in pgsql?

Thanks in advance for any notes and suggestions,

Cheers, Andre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleus Mantzios 2006-01-23 11:36:19 DBMirror.pl performance change
Previous Message A. Kretschmer 2006-01-23 11:01:29 Re: Postgresql/