Re: [patch] A \pivot command for psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: [patch] A \pivot command for psql
Date
Msg-id 9c8c0211-b232-45bd-a865-e7f2d162599a@mm
Whole thread Raw
In response to Re: [patch] A \pivot command for psql  (David Fetter <david@fetter.org>)
Responses Re: [patch] A \pivot command for psql
List pgsql-hackers
    David Fetter wrote:

> I'm working up a proposal to add (UN)PIVOT support to the back-end.

I was under the impression that a server-side PIVOT *with dynamic
columns* was just unworkable as an SQL query, because it couldn't
be prepared if it existed.

I am wrong on that? I feel like you guys are all telling me that \pivot
should happen on the server, but the point that it would not be
realistic to begin with is not considered.


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



pgsql-hackers by date:

Previous
From: "Steve Thames"
Date:
Subject: pg_dump and search_path
Next
From: "Daniel Verite"
Date:
Subject: Re: [patch] A \pivot command for psql