$chiubaca / notes / fleeting / 2020-12-01
  • Worked through more postgres tutorials. Completed Section 5. Set Operations unions, interesets and except clauses.
  • Got pretty confused working through Section 6. Grouping sets, Cube, and Rollup , but this youtube vide explained it well and I finally grocked it. I just dont understand when you want to have grouped data like that. CUBE and ROLLUP functions are interesting shortcuts to producing variations of grouped data from your table, but simarly, i just dont know why you would want to work with data like that. seems to makes more sense for it to be seperate queries to me.
Edit on GitHub ✏️

Hey I'm Alex Chiu 👋. These are my notes for literally anything.

I'm using the Zettelkasten method to organise my thoughts here.

My more polished writings are published to my main blog at chiubaca.com

Follow me on: Github / X (Twitter) / Mastodon / LinkedIn