Using Window Functions to Set Values: A Postgres Approach.

Using Common Table Expressions to Modify Data and Avoid Foreign Key Violations with PostgreSQL