“In many cases basic functions are not enough and it makes sense to create your own code to make sure that calculations can still be done on the server side.”
Bruce Momjian discusses how Postgres supports both traditional JOIN syntax, which uses the WHERE clause to specify joined columns, and ANSI JOIN syntax, that uses the word JOIN in the FROM clause.
Audit logs can be useful for a number of purposes, and there’s a bunch of ways you can implement them. Here’s one approach that aims to make it a bit easier.
