News for hackers. Stuff that matters.

A comment on Lesser-known Postgres features.

Re:Lesser-known Postgres features by netcraft on Tuesday November 09, 2021 @11:13AM (#29163641)
Great article, always learn a lot from this author.

Here is another way I have used to do pivot tables / crosstab in postgres where you have a variable number of columns in the output:

https://gist.github.com/ryanguill/101a19fb6ae6dfb26a01396c53...

You can try it out here: https://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=5dbbf7eadf0ed...

[ Parent | on HN ]
Re:Lesser-known Postgres features by leephillips on Tuesday November 09, 2021 @11:58AM (#29164178)
Yes, just the per-DB history was worth the price of admission. Too bad there is no RSS feed.
[ Parent | on HN ]
Re:Lesser-known Postgres features by gobblegobble2 on Tuesday November 09, 2021 @12:55PM (#29164941)
The feed is here: https://hakibenita.com/feeds/all.atom.xml.
[ Parent | on HN ]
Re:Lesser-known Postgres features by leephillips on Tuesday November 09, 2021 @01:02PM (#29165032)
Thanks!
[ Parent | on HN ]