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)

string is the string or column that you want to convert to uppercase.

Here’s an example of using the UPPER function:

SELECT UPPER('Hello, World!'); -- Returns 'HELLO, WORLD!'

You can also use the UPPER function with column values in a table. For instance, if you have a table named employees with a column named name, you can convert all first names to uppercase like this:

SELECT UPPER(name) FROM employees;

This query will return a result set with all the name values in uppercase.

String Functions

PostgreSQL – POSITION Function

ByAdmin August 14, 2023August 14, 2023

The POSITION function, also known as POSITION(substring IN string) or STRPOS(string, substring), is used to find the starting position of a substring within a given string. It returns the position of the first occurrence of the specified substring within the string. The position is a 1-based index, meaning the first character of the string is…

String Functions

PostgreSQL – TRANSLATE Function

ByAdmin August 14, 2023August 14, 2023

The TRANSLATE function is used to replace all occurrences of a set of characters in a given string with corresponding characters from another set. This function is particularly useful for performing character-level substitutions or transformations. The syntax of the TRANSLATE function is as follows: TRANSLATE(string, from_set, to_set) where string is the input string in which…

String Functions

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…

String Functions

PostgreSQL – FORMAT Function

ByAdmin August 14, 2023August 14, 2023

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…

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 – 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…

Related

Similar Posts