Case in TimescaleDB

Introduction In this document, we’ll explain a specific type of branching using Case in TimescaleDB, including: What? What does the “CASE” statement do? Why? In what circumstances will we gain from use of case branching? Where and how? How can we use the “CASE” branch and where/when can we use it in the SQL we … Continued

The Quote_Literal Function in Postgres SQL

Introduction In this article, we will study the Quote_Literal function in Postgres SQL, including the following perspectives: What? What is the general idea and syntax of the QUOTE_LITERAL() function? Why? In what circumstances do we use the QUOTE_LITERAL function in our PostgreSQL queries? How? How do we use the QUOTE_LITERAL function in our SQL? Similar … Continued

Using Postgres Case in SQL

Introduction In this article, we will explain the Postgres Case SQL statement, including: What? What does “CASE” do? Why? At what times can we benefit from use of this statement? How and Where? How can we use a “CASE” statement and where/when can we use it in the SQL we write? Prerequisites Beginner experience writing … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.