PostgreSQL – LEFT Function

ByAdmin August 14, 2023September 23, 2023

The LEFT function in postgreSQL is used to extract a specified number of characters from the beginning (left side) of a string. The syntax of the LEFT function is as follows:

LEFT(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 left side of the input string.

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

SELECT LEFT('Hello, World!', 5);

In this example, the result would be the string 'Hello', because the LEFT function extracted the first 5 characters from the input string.

Keep in mind that if the specified length is greater than the length of the input string, the LEFT function will simply return the entire input string.

SELECT LEFT('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.

String Functions

PostgreSQL – REPLACE Function

ByAdmin August 14, 2023August 14, 2023

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…

String Functions

PostgreSQL – STRPOS Function

ByAdmin September 22, 2023September 22, 2023

The strpos function in PostgreSQL database is used to find the position of a substring within a given string. It returns the position (counting from 1) of the first occurrence of the substring within the string. If the substring is not found, it returns 0. Here’s the syntax for the strpos function: strpos(source_string, search_string) Here’s…

String Functions

PostgreSQL – CHR Function

ByAdmin August 14, 2023August 20, 2023

The CHR function is used to return the character corresponding to a specified ASCII code or Unicode code point. It’s a convenient way to generate characters based on their numeric representations. The syntax of the CHR function is as follows: CHR(code) where code is the numeric code that represents the character you want to retrieve….

String Functions

PostgreSQL – UPPER Function

ByAdmin September 21, 2023September 21, 2023

The UPPER function is used to convert all characters in a given string to uppercase. It takes a string as an argument and returns a new string where all alphabetic characters have been converted to their uppercase equivalents. Here’s the basic syntax of the UPPER function: UPPER(string) Here’s an example of using the UPPER function:…

String Functions

PostgreSQL – REGEX_REPLACE Function

ByAdmin August 14, 2023August 14, 2023

The REGEXP_REPLACE function is used to replace substrings within a string based on a regular expression pattern. It allows you to perform advanced pattern-based replacements on text data. The syntax of the REGEXP_REPLACE function is as follows: REGEXP_REPLACE(string, pattern, replacement, flags) where string is the input string in which you want to perform replacements. and…

String Functions

PostgreSQL – SPLIT_PART Function

ByAdmin August 14, 2023August 14, 2023

The SPLIT_PART function is used to extract a specific part of a string that is divided into segments by a delimiter. This function is particularly useful when you have a string that contains multiple segments separated by a delimiter, and you want to extract a specific segment based on its position. The syntax of the…

Related

Similar Posts