Thoughts about SQL

Posts
Additional Resources

Categories

Recent Posts

DISTINCT is not a function
INTERVAL advantages
Helpful error messages
Unique JSON Features in PostgreSQL
Gapless number generation
How to deal with cyclic foreign keys
Dynamic unpivot with Postgres
JSON Path support in Postgres 12
Migrate your mindset too
Epoch Mania
On the choice of datatypes
Assignment performance in PL/pgSQL
The power of range types in Postgres
Fizzbuzz with modern SQL
Converting query results to JSON

Tags

Crosstab (1) Database design (3) Date (2) Dynamic sql (1) Foreign keys (1) Interval (1) Json (3) Migration (1) Oracle (2) Performance (4) Pivot (1) Pl/pgsql (1) Postgresql (16) Sequence (1) Sql (11) Timestamp (2) Unpivot (2)

RSS

© 2022 Thomas Kellerer. Generated with Hugo and Mainroad theme.