Hi Ășt 5. 1. 2021 v 19:45 odesĂlatel Joe Conway <m...@joeconway.com> napsal:
> On 1/5/21 12:11 PM, Tim Clarke wrote: > > imho the crosstab() function isn't a good implementation. The biggest > failure it > > has is that you must know exactly how many output columns you will have > in the > > result /_prior to running it > > > *That* is a function of how Postgres set returning functions work, and not > specific to crosstab(). It is not easily fixed. Patches to fix that would > be > welcomed! > https://www.postgresql.org/message-id/flat/CAFj8pRC%2BhNzpH%2B0bPRCnqNncUCGjEvpwX%2B0nbhb1F7gwjYZZNg%40mail.gmail.com#9b3fbdd968c271668049a103bfc93880 Regards Pavel > > Joe > > -- > Crunchy Data - http://crunchydata.com > PostgreSQL Support for Secure Enterprises > Consulting, Training, & Open Source Development > >