Re: Enahancement in pgsql - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Enahancement in pgsql
Date
Msg-id CAKFQuwbwVhr98u9gy5vQmDfoL4iFR+wLmY_j71O2-w8bRT_yGw@mail.gmail.com
Whole thread Raw
In response to Enahancement in pgsql  (shailesh singh <shailesh.h.singh2@gmail.com>)
List pgsql-bugs
On Wed, Mar 14, 2018 at 11:37 PM, shailesh singh <shailesh.h.singh2@gmail.com> wrote:
Hi team,
this is an enhancement not a bug so sending in a general inbox.

​That may have been your intent but that isn't what happened.
I have want to change rows to column without group by( there is no group by and filter help which is online).
In java iterating those rows will take extra time, I want to cut that time a little and I have to show the data.
Please if you can do something for it.

​I don't understand what you are trying to communicate here.  Perhaps an example query with desired output ​would aid others is evaluating your need and possible suggesting alternatives that work today and not just maybe some years from now.  In particular see https://www.postgresql.org/docs/10/static/tablefunc.html if want you are wanting is some kind of Pivot Table feature.

David J.

pgsql-bugs by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: Postgres 10.3 delete on partition table cannot execute, out ofmemory.
Next
From: Yavuz TANRIVERDİ
Date:
Subject: contrib/start-scripts/freebsd script fails with Ambiguous output redirect.