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

Reverse Function in Postgres SQL

Introduction In this tutorial, we will learn to use the Reverse function in Postgres SQL to manipulate strings, to isolate words in multi-word text. We’ll also go over: What? What does the REVERSE function do and how do we use this function in our SQL execution? Why? When do we need the reverse() function? A … Continued

Use of Floor Function in Postgres SQL

Introduction In this tutorial, we learn to use the Floor function in our Postgres SQL queries. We’ll begin easy and then add some complexity in order to best understand the scope and use of this function. Here we will explore: What? From the highest level, what does the FLOOR function do? Why? What are a … Continued

Left Function in Postgres SQL

Introduction Here we learn in this tutorial session to use the Left function to achieve various string-related tasks in Postgres SQL, including: What? What does the LEFT function do? How? How do we use the Left() function in our PostgreSQL queries? What parameters does it use? Why? When do we need this text function in … Continued

Use of Round Function in Postgres SQL

Introduction In this article, we will study the Round function in Postgres SQL from three perspectives, including: What? What does the ROUND() function do and what is the syntax? Why? In what circumstances do we use the ROUND function in our Postgres SQL? How? How do we use this function in our SQL database queries? … Continued

Use of Random Function in Postgres SQL

Introduction In this article, we’ll learn to use the Random function in our Postgres SQL queries. We’ll start simple and then build a mini-project in order to better understand the scope of this function. Here we will discuss: What? From a high level, what does the RANDOM function do? Why? What are a couple situations … Continued

Use of Max function in Postgres SQL

Introduction In this article, we’ll learn to use the aggregate Max function in our Postgres SQL commands from multiple perspectives, to gain a deeper level of understanding. Here we will discuss: What? From a beginner perspective, what the MAX function does? Why? In what situations should we use the Max() function? How? How do we … Continued

Use of Min function in Postgres SQL

Introduction In this tutorial, we will learn to use the aggregate Min function in our Postgres SQL commands from more than one perspective, so as to gain as deep a level of understanding as possible. Here we will discuss: What? From a beginner level coder perspective, what is the MIN function and what does it … Continued

Postgres Strpos Function and Nested Strings in SQL

Introduction In this tutorial, we will show how to use the Postgres Strpos function with nested strings in SQL to isolate words in multi-word phrases, including: What? What does the PostgreSQL STRPOS function do? How? How do we use this function in our PostgreSQL SQL commands? Why? When do we need these functions? We’ve included … 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.