| From: | David Johnston <polobo(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: un-pivot with crosstab? |
| Date: | 2013-01-02 20:32:29 |
| Message-ID: | 1357158749208-5738530.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kirk Wythers wrote
> I am trying to follow the example given below, but in reverse. I have
> something like table2, that I am trying to "un-pivot" to look like table1…
> And I seem to be having a booger of a time.
I see nothing in the tablefunc/crosstab documentation to suggest this can be
done. You will need to use multiple queries and combine them using "UNION
ALL" to accomplish your goal.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/un-pivot-with-crosstab-tp5738518p5738530.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2013-01-02 21:02:20 | Re: Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail? |
| Previous Message | Steve Crawford | 2013-01-02 19:22:16 | Re: Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail? |