Postgres Pro
Downloads
Home   >   mailing lists

Re: [patch] Proposal for \rotate in psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [patch] Proposal for \rotate in psql
Date
Msg-id CAFj8pRCC8=x7FUUVzy7EbdrRVehHbNEjpgOCSvcCyKQ_u=VKHw@mail.gmail.com
Whole thread Raw
In response to Re: [patch] Proposal for \rotate in psql  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [patch] Proposal for \rotate in psql
List pgsql-hackers
Tree view


2015-12-13 8:14 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:


2015-12-10 19:29 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:



postgres=# \crosstabview 4 +month label

Maybe using optional int order column instead label is better - then you can do sort on client side

so the syntax can be "\crosstabview VCol [+/-]HCol [[+-]HOrderCol]

here is patch - supported syntax: \crosstabview VCol [+/-]HCol [HOrderCol]

Order column should to contains any numeric value. Values are sorted on client side

fixed error messages

 

Regards

Pavel
 

Regards

Pavel

 
┌──────────────────────────┬───────┬───────┬────────┬───────┬───────┬───────┬───────┬───────┬───────┬───────┬───────┐
│         customer         │  led  │  úno  │  bře   │  dub  │  kvě  │  čen  │  čec  │  srp  │  zář  │  říj  │  lis  │
╞══════════════════════════╪═══════╪═══════╪════════╪═══════╪═══════╪═══════╪═══════╪═══════╪═══════╪═══════╪═══════╡
│ A**********              │       │       │        │       │       │       │       │       │       │ 13000 │       │
│ A********                │       │       │ 8000   │       │       │       │       │       │       │       │       │
│ B*****                   │       │       │        │       │       │       │       │       │       │       │ 3200  │
│ B*********************** │       │       │        │       │       │       │       │       │ 26200 │       │       │
│ B*********               │       │       │        │       │       │       │ 14000 │       │       │       │       │
│ C**********              │       │       │        │ 7740  │       │       │       │       │       │       │       │
│ C***                     │       │       │        │       │       │       │       │       │ 26000 │       │       │
│ C*****                   │       │       │        │ 12000 │       │       │       │       │       │       │       │
│ G*******                 │ 30200 │ 26880 │ 13536  │ 39360 │ 60480 │ 54240 │ 44160 │ 16320 │ 29760 │ 22560 │ 20160 │
│ G***************         │       │       │        │       │       │ 25500 │       │       │       │       │       │
│ G**********              │       │       │        │       │       │ 16000 │       │       │       │       │       │
│ I*************           │       │       │        │       │       │       │       │ 27920 │       │       │       │
│ i****                    │       │       │        │ 13500 │       │       │       │       │       │       │       │
│ n*********               │       │       │        │       │       │       │ 12600 │       │       │       │       │
│ Q**                      │       │       │        │       │ 16700 │       │       │       │       │       │       │
│ S*******                 │       │       │        │       │       │       │ 8000  │       │       │       │       │
│ S*******                 │       │       │        │       │ 5368  │       │       │       │       │       │       │
│ s*******                 │       │       │ 5000   │ 3200  │       │       │       │       │       │       │       │
└──────────────────────────┴───────┴───────┴────────┴───────┴───────┴───────┴───────┴───────┴───────┴───────┴───────┘
(18 rows)

 

Regards

Pavel
 

 
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite





Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [patch] Proposal for \rotate in psql
Next
From: Konstantin Knizhnik
Date:
Subject: Tee for COPY