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.

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

SELECT CHR(65) AS character;

In this example, the result would be the character 'A', as the numeric code 65 corresponds to the ASCII code for the uppercase letter 'A'.

You can also use the CHR function with Unicode code points:

SELECT CHR(9731) AS emoji;

In this case, the result would be the character '☃', which is a snowman emoji. The Unicode code point 9731 represents this particular emoji character.

The CHR function is particularly useful when you need to include special characters or symbols in your SQL queries or reports. Just make sure to use the appropriate code point for the character you want to generate.

String Functions

PostgreSQL – LTRIM Function

ByAdmin September 22, 2023September 22, 2023

The ltrim function is used to remove characters from the left end (beginning) of a string. It takes two arguments: the input string and a list of characters to be removed from the left side of the input string. Here’s the syntax for the ltrim function: ltrim(input_string, characters_to_remove) where The ltrim function will return a…

String Functions

PostgreSQL – TRIM Function

ByAdmin August 13, 2023August 13, 2023

The TRIM() function is used to remove specified characters or whitespace from the beginning and/or end of a string. It’s often used to clean up or manipulate strings by removing unwanted leading or trailing characters. The syntax of the TRIM() function is as follows: TRIM([ [ BOTH | LEADING | TRAILING ] trim_character FROM ]…

String Functions

PostgreSQL – OVERLAY Function

ByAdmin September 23, 2023September 23, 2023

The OVERLAY function is used to replace a portion of a string with another string. It allows you to specify the position within the original string where the replacement should start and the length of the portion to replace. Here’s the basic syntax of the OVERLAY function: OVERLAY(string1 PLACING string2 FROM start_position [FOR length]) Here’s…

String Functions

postgreSQL – SUBSTRING Function

ByAdmin August 14, 2023August 14, 2023

The SUBSTRING function is used to extract a substring from a given string. It allows you to extract a portion of a string based on a specified starting position and length. The syntax of the SUBSTRING function is as follows: SUBSTRING(string FROM start_position [FOR length]) where string is the input string from which you want…

String Functions

PostgreSQL – LOWER Function

ByAdmin September 21, 2023September 21, 2023

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

String Functions

PostgreSQL – REPEAT Function

ByAdmin September 21, 2023September 21, 2023

The REPEAT function is used to repeat a string a specified number of times and concatenate the repetitions together to form a longer string. It takes two arguments: the string you want to repeat and the number of times you want to repeat it. Here’s the basic syntax of the REPEAT function: REPEAT(string, count) Here’s…

Related

Similar Posts