PostgreSQL – ASCII Function

ByAdmin August 14, 2023August 14, 2023

The ASCII function is used to return the ASCII code value of the first character in a given string. The ASCII code is a numerical representation of a character in the ASCII character set.

The syntax of the ASCII function is as follows:

ASCII(string)

and string is the input string for which you want to obtain the ASCII code value of the first character.

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

SELECT ASCII('A') AS ascii_value;

In this example, the result would be the integer 65, as the ASCII code value for the uppercase letter 'A' is 65.

Keep in mind that the ASCII function only considers the first character of the input string. If you provide a longer string, only the first character will be evaluated.

If the input string is empty, the ASCII function will return NULL.

SELECT ASCII('') AS ascii_value;

In this case, the result would be NULL.

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 – RPAD Function

ByAdmin September 22, 2023September 22, 2023

The rpad function in PostgreSQL database is used to right-pad a string with a specified character or a set of characters until the resulting string reaches a specified length. This function is often used to format strings to a fixed width. Here’s the syntax for the rpad function: rpad(input_string, length, pad_string) The rpad function takes…

String Functions

PostgreSQL – CONCAT Function

ByAdmin August 13, 2023August 13, 2023

The CONCAT() function is used to concatenate two or more strings together. It takes multiple string arguments and returns a single string by concatenating those arguments in the order they are provided. If any of the arguments are NULL, the resulting concatenated string will also be NULL. The syntax of the CONCAT() function is as…

String Functions

PostgreSQL – RIGHT Function

ByAdmin August 14, 2023September 23, 2023

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…

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 – MD5 Function

ByAdmin August 14, 2023August 14, 2023

The MD5 function is used to calculate the MD5 hash value of a given input string. MD5 (Message Digest Algorithm 5) is a widely used cryptographic hash function that produces a fixed-size 128-bit (16-byte) hash value, typically represented as a 32-character hexadecimal number. The syntax of the MD5 function is as follows: MD5(string) where string…

Related

Similar Posts