PostgreSQL – RIGHT Function

ByAdmin

The RIGHT function in postgreSQL is used to extract a specified number of characters from the end (right side) of a string. The syntax of the RIGHT function is as shown below:

RIGHT(string, length)

where string is the input string from which you want to extract characters,

and length is the number of characters you want to extract from the right side of the input string.

Here’s an example of how you might use the RIGHT function in a SQL query:

SELECT RIGHT('Hello, World!', 6);

In this example, the result would be the string 'World!', because the RIGHT function extracted the last 6 characters from the input string.

If the specified length is greater than the length of the input string, the RIGHT function will simply return the entire input string.

SELECT RIGHT('Hi', 5);

In this case, the result would still be the string 'Hi', because the length of the input string is less than the specified length.

Similar Posts

PostgreSQL – REPLACE Function

ByAdmin

The REPLACE function is used to replace all occurrences of a specified substring within a given string with another substring. The syntax of the REPLACE function is as follows: REPLACE(string, old_substring, new_substring) where string is the input string in which you want to perform replacements, and old_substring is the substring you want to replace within…

PostgreSQL – FORMAT Function

ByAdmin

The FORMAT function is used to format a string using placeholders that are replaced with corresponding values. It’s a powerful function that allows you to create formatted strings with specific patterns and insert values into those patterns. The syntax of the FORMAT function is as follows: FORMAT(format_string, value1, value2, …) where format_string is the string…