"joining" table records

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: "joining" table records
Date: 2017-06-21 16:47:02
Message-ID: 7c086e51-50a9-549a-73dd-c9559c298694@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have this table

rec_code | rec_date | int1 | int2 |
10 2014-07-21 3 4
11 2014-07-21 5
10 2015-01-04 1 2
11 2016-02-05 6

That's the result I need to get from a SELECT statement

rec_date | int1 | int2 | tempvalue
2014-07-21 3 4 5
2015-01-04 1 2
2016-02-05 6

(lines with matching date "joined" into one, using another column/alias to hold the "joined row" value)

I'm stuck while searching a way to "select int1, int2 from tbl where rec_code = 10" UNION (select int1 from tbl where rec_code = 11) as tempvalue *where rec_date is the same*
(read this as pseudocode... I also thought about a mix of DISTINCT and UNION, but have no idea on how to put things together).

Is it so simple I can't see it?
Is it the hot weather and the broken conditioner? :-)
Do I need to RTFM more in deep? :-))

I don't think it matters, but postgresql 9.1.21 x64 on Windows 7

Hope I've been clear enough

Cheers,
Moreno.-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2017-06-21 16:50:06 Re: Cookbook for doing installation and configuration of PostgreSQL on Redhat
Previous Message Emilie Laffray 2017-06-21 16:37:20 Re: Question about jsonb and data structures