Thread: Enahancement in pgsql

Enahancement in pgsql

From
shailesh singh
Date:
Hi team,
this is an enhancement not a bug so sending in a general inbox.
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.



Thanks and Warm Regards
Shailesh Singh

Re: Enahancement in pgsql

From
"David G. Johnston"
Date:
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.