Why Use WHERE 1=2 in SQL
Some time ago I wrote a blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
Postgres Blog Archives, by Peter Whyte (SQL Server Database Admin). Includes Postgres posts from a SQL Server DBA's perspective!
Some time ago I wrote a blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
This post is a short note on how to install Postgres on Ubuntu 20.04.I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version.
This post contains a SQL script that will return all schemas, tables and columns in Redshift or Postgres.I’m combining the Redshift and Postgres database blog categories here.
A common SQL question is, why would anyone use WHERE 1=1 in their queries? And what does it do?The WHERE 1=1 condition means WHERE TRUE.
In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!
A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation.
PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched.