3 ms·

I admit that I only skimmed the article, but I'm wondering if psql's \crosstabview would help?

• sgarman 3y ago
  OP says it needs to be a function in sql and backslash commands are psql commands not queries. Probably would not suite their case.
  • leononame 3y ago
    Yes, that's exactly right. Other requirements around this whole thing force us to do this in a function and not through psql. We've actually been thinking about using pl{perl,python,rust} instead because this approach works, but is annoying.