Re: crosstab/repivot...any interest?

2019-02-26 Thread Merlin Moncure
On Tue, Feb 26, 2019 at 8:31 AM Joe Conway wrote: > On 2/25/19 8:34 PM, Merlin Moncure wrote: > > The interface I'm looking at is: > > SELECT repivot( > > query TEXT, > > static_attributes INT, /* number of static attributes that are > > unchanged around key; we need this in our usages */ >

Re: crosstab/repivot...any interest?

2019-02-26 Thread Joe Conway
On 2/25/19 8:34 PM, Merlin Moncure wrote: > No worries, sir! Apologies on the late reply.  I've made some headway on > this item.  Waiting for postgres to implement the SQL standard pivoting > (regardless if it implements the cases I need) is not an option for my > personal case. I can't use the

crosstab/repivot...any interest?

2019-02-25 Thread Merlin Moncure
On Fri, Jan 25, 2019 at 9:14 PM Morris de Oryx wrote: > > Hello, I'm not a C coder and can't helpbut I love cross-tab/pivot tables. They're the best, and just fantastic for preparing data to feed into various analysis tools. The tablefunc module is helpful, but a bit awkward to use (as I

Re: crosstab/repivot...any interest?

2019-01-25 Thread Morris de Oryx
Hello, I'm not a C coder and can't helpbut I *love* cross-tab/pivot tables. They're the best, and just fantastic for preparing data to feed into various analysis tools. The tablefunc module is helpful, but a bit awkward to use (as I remember it.) >From a user's point of view, I

Re: crosstab/repivot...any interest?

2019-01-25 Thread David Fetter
On Fri, Jan 25, 2019 at 04:31:00PM -0600, Merlin Moncure wrote: > On Fri, Jan 25, 2019 at 3:16 PM David Fetter wrote: > > > > On Fri, Jan 25, 2019 at 02:21:55PM -0600, Merlin Moncure wrote: > > > Hackers, > > > > > > We have a strong need to make a variant to the crosstab interface so > > > that

Re: crosstab/repivot...any interest?

2019-01-25 Thread Merlin Moncure
On Fri, Jan 25, 2019 at 3:16 PM David Fetter wrote: > > On Fri, Jan 25, 2019 at 02:21:55PM -0600, Merlin Moncure wrote: > > Hackers, > > > > We have a strong need to make a variant to the crosstab interface so > > that data that is pivoted one way would be sent through a crosstab > > like

Re: crosstab/repivot...any interest?

2019-01-25 Thread David Fetter
On Fri, Jan 25, 2019 at 02:21:55PM -0600, Merlin Moncure wrote: > Hackers, > > We have a strong need to make a variant to the crosstab interface so > that data that is pivoted one way would be sent through a crosstab > like function so that it would be pivoted another way. For example, > if you

crosstab/repivot...any interest?

2019-01-25 Thread Merlin Moncure
Hackers, We have a strong need to make a variant to the crosstab interface so that data that is pivoted one way would be sent through a crosstab like function so that it would be pivoted another way. For example, if you had row 0: a1, a2, a3, k1, c1, c2, ... row 1: a1, a2, a3, k2, c1, c2, ...