Communicode

A blog dedicated to sharing knowledge and opinion regarding technology in general and software development in particular

  1. Materialized Views in PostgreSQL

  2. Triggers in SQL

  3. Sequences in PostgreSQL

  4. IS NOT DISTINCT FROM in PostgreSQL

  5. IS DISTINCT FROM in PostgreSQL

  6. to_json() in PostgreSQL

  7. array_agg() in PostgreSQL

  8. string_agg() in PostgreSQL

  9. json_agg() in PostgreSQL

  10. COALESCE() in SQL