DB News – 2020 Week 6

The first edition. Thanks for reading. 1. NULL Values in SQL Queries Handling NULL values in SQL is tricky to say the least. An interesting tour of ternary logic. 2. pg_ctl Tips and Tricks pg_ctl…

Search for a column name in any table

Most directly, you can run this in SQL Server to confirm that a column exists — but that alone is only somewhat useful. Really what you want to know is both that the column exists…