agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Gerardo Herzig <gherzig@fmed.uba.ar>
To: Olivier Leprêtre <o.lepretre@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Window ?
Date: Wed, 13 Jun 2018 15:22:14 +0000 (UTC)
Message-ID: <1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar> (raw)
In-Reply-To: <1229836812.269466.1528903219547.JavaMail.zimbra@fmed.uba.ar>
References: <5b212b57.1c69fb81.2e3b4.1d26@mx.google.com>
<CAKFQuwY2E1GUmOoNDo-UdxiOSg4gErdpmzDYV5zRJ6JhBO60Uw@mail.gmail.com>
<5b2134ec.1c69fb81.7dd50.7e8f@mx.google.com>
----- Mensaje original -----
> De: "Olivier Leprêtre" <o.lepretre@gmail.com>
> Para: "pgsql-sql" <pgsql-sql@lists.postgresql.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
view thread (5+ messages)
Message-ID: <1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar>
Permalink: ../1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar/
Also on: postgresql.org/message-id/1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gherzig@fmed.uba.ar, o.lepretre@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: Window ?
In-Reply-To: <1021212329.270013.1528903334631.JavaMail.zimbra@fmed.uba.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox