From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Carson Farmer <carson(dot)farmer(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, Carson Farmer <Carson(dot)Farmer(at)nuim(dot)ie> |
Subject: | Re: origins/destinations |
Date: | 2009-05-19 17:25:13 |
Message-ID: | 4A12EB79.2070603@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Carson Farmer wrote:
> Hi list,
>
> I have (what I thought was) a relatively simple problem, but my
> knowledge of sql is just not good enough to get this done:
>
> I have a table which is basically a number of individuals with both
> their origin and destination as columns (see Table 1). In this case,
> origins and destinations are the census area in which they and work.
> What I would like to do is generate an nxn matrix (preferably output to
> csv but I'll take what I can get), where origins are on the y axis, and
> destinations on the x axis (see Table 3).
Google a little for crosstab queries with the tablefunc add-ons in the
contrib/ directory.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Shakil Shaikh | 2009-05-19 17:55:25 | Locking to restrict rowcounts. |
Previous Message | Carson Farmer | 2009-05-19 16:57:14 | origins/destinations |