subject:"\[sqlite\] Table\-valued functions as PIVOT"

Re: [sqlite] Table-valued functions as PIVOT

2017-09-15 Thread petern

Richard is right. Unless you're discarding transformed rowsets, your pivots will become stale. If you need a live pivot, I recently disclosed a SQLite native language "stored procedure" for computing live pivot views on this mailing list:

Re: [sqlite] Table-valued functions as PIVOT

2017-09-14 Thread Richard Hipp

On 9/14/17, Gary Briggs wrote: > It's been a while since anyone has brought up PIVOT, and none that I > can see since table-valued functions were added [in 3.9.0, I think?] > > Has anyone successfully implemented PIVOT using table-valued functions? > > I'm in the situation

[sqlite] Table-valued functions as PIVOT

2017-09-14 Thread Gary Briggs

It's been a while since anyone has brought up PIVOT, and none that I can see since table-valued functions were added [in 3.9.0, I think?] Has anyone successfully implemented PIVOT using table-valued functions? I'm in the situation again where I'd like a better way to pivot, where knowledge of