Re: Window ?
Gerardo Herzig <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <[email protected]> |
----- Mensaje original ----- > De: "Olivier Leprêtre" <[email protected]> > Para: "pgsql-sql" <[email protected]> > 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