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
