Crosstab-style query in pure SQL

From: dev(at)archonet(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Crosstab-style query in pure SQL
Date: 2003-01-13 12:47:01
Message-ID: 1493.192.168.1.16.1042462021.squirrel@mainbox.archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

TIA all

I have a table containing milestones achieved for projects, marked as
being in particular quarters.

CREATE TABLE milestones (
proj_id int4,
sortorder SERIAL,
qtr int4,
description varchar(200)
);

Now I need the milestone descriptions output across the page like:
proj_id | q1 | q2 | q3 | q4
and sorted according to "sortorder".

Judicious use of CASE can get me the quarterly columns but I need to
eliminate holes. Any clever ideas without resorting to procedural
solutions (either table function or application code)?

TIA

- Richard Huxton

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-01-13 15:31:10 Re: Unique indexes not unique?
Previous Message dev 2003-01-13 12:32:05 Re: Unique indexes not unique?