Substring in TimescaleDB

Introduction In this document, we’ll learn to use Substring in TimescaleDB, along with the position and reverse functions for making changes to text with SQL to isolate strings. This lesson includes the following: What do the POSITION and SUBSTRING functions do? How do we use these functions in TimescaleDB database SQL? When do we want … Continued

Substring in CockroachDB

Introduction In this document, we will learn to use substring in CockroachDB, along with the position and reverse functions for making changes to text with SQL to isolate strings. This lesson includes the following: What do the POSITION and SUBSTRING functions do? How do we use these functions in Cockroach database SQL? 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

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

Postgres Substring and Position Functions in SQL

Introduction In this article, we will learn to use the Postgres Substring and Position functions SQL when manipulating strings to isolate words in multi-word strings, including: What? What do the SUBSTRING and POSITION functions do? How? How do we use these functions in our SQL execution? Why? When do we need these functions? A real … 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.