• Sunday

  Dec 17, 2023

  • Private work.
  • My ancestry is ~68% german/french ~25% british/irish ~2% native american.
  • Remember (select1) union (select2) in psql. Totally fine with CTEs and everything else. Must match columns. UNION ALL won’t deduplicate.
  • You can also group by then order by and use an aggregate function in the latter, of course.
  • Caught up on advents, niners, warriors, aquarium maintenance, etc.
  • Remember you can group by with multiple cols.