From: | Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> |
---|---|
To: | Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Window ? |
Date: | 2018-06-13 15:22:14 |
Message-ID: | 1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
----- Mensaje original -----
> De: "Olivier Leprêtre" <o(dot)lepretre(at)gmail(dot)com>
> Para: "pgsql-sql" <pgsql-sql(at)lists(dot)postgresql(dot)org>
> Enviados: Miércoles, 13 de Junio 2018 12:14:45
> Asunto: RE: Window ?
> Thanks David, Gerardo,
>
>
>
> I had a look to crosstab functions but wasn't able to make them work,
> documentation is not precise enough to me, I would appreciate if someone has a
> working sample. Based on your suggestion, I will try again anyway. The main
> difficulty is that I have not only one column but half a dozen taht I would
> like to appear
>
>
>
> road 1 colA colB colC colD colE ColF colA colB colC colD colE ColF colA colB
> colC colD colE ColF ...
>
> road 2 colA colB...
>
>
>
> for each road.
>
Look at section 39.1.4. of https://www.postgresql.org/docs/current/static/tablefunc.html
There is a working example that looks pretty close to what you want.
HTH
Gerardo
From | Date | Subject | |
---|---|---|---|
Next Message | Brice André | 2018-07-03 04:28:48 | Problem inserting binary data in bytea column of UTF-8 database |
Previous Message | Olivier Leprêtre | 2018-06-13 15:14:45 | RE: Window ? |