This page lists some features I plan to cover next (in no particular order).
lateral
(covered in slides)with recursive
(covered in slides; example for an alternativelistagg
implementation)array
(array_agg
andarray(<query>)
are mentioned as alternative tolistagg
)Multisets
within group
(percentile_cont
,percentil_dist
, ...) (seelistagg
; covered in slides)Transactions and savepoints
Transaction isolation levels
Temporary tables
Statement-level triggers
XML
Temporal databases as they become more widely supported (roughly covered in slides)
Updatable views
Boolean data types
Collations: locale aware string comparisons
cast
check
constraintsRow-values