ViewsSingle Table ViewsUsing Triggers to Update ViewsMaterialized ViewsHandy ConstructionsDISTINCT ONLIMIT and OFFSETShorthand CastingMultirow InsertILIKE for Case-Insensitive SearchANY Array SearchSet-Returning Functions in SELECTRestricting DELETE, UPDATE, and SELECT from Inherited
TablesDELETE USINGReturning Affected Records to the UserUPSERTs: INSERT ON CONFLICT UPDATEComposite Types in QueriesDollar QuotingDOFILTER Clause for AggregatesPercentiles and ModeWindow FunctionsPARTITION BYORDER BYCommon Table ExpressionsBasic CTEsWritable CTEsRecursive CTELateral JoinsWITH ORDINALITYGROUPING SETS, CUBE, ROLLUP