While Loop TimescaleDB

Introduction In this lesson, we will learn to enhance the power of our database queries using the While loop in TimescaleDB. This lesson will include but not be limited to: What? What does “WHILE” do and what’s the syntax? Why and how? Why and how do we use a “WHILE” loop and where/when can we … Continued

RTrim Function in Postgres SQL

Introduction In this article we use the RTrim function in Postgres SQL to attain various text-related results, including: What? What is the syntax of the RTRIM function and what does it do? How do we use the RTrim() function in our PostgreSQL queries and what parameters does rtrim() use? Why? Why and when do we … Continued

Repeat Function in Postgres SQL

Introduction In this tutorial to use the Repeat function to achieve various text- and integer- related tasks in Postgres SQL, including: What? What’s the syntax of the REPEAT function and what does the function do? How do we use the Repeat() function in our PostgreSQL queries? What parameters does it use? Why? When do we … 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.