October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL includes several functions that modify string-related data. These functions are particularly useful for controlling output displays and/or normalizing data input.
The ASCII function returns the ASCII value for the supplied character.
ASCII(chr) chr—The character to determine the ASCII value of.
ASCII('A') → 65
ASCII('Apple') → 65 In the case of multiple characters being supplied to the ASCII function, only the first is evaluated.
The CHR function returns the character that corresponds to the ASCII value provided.
CHR(val) val—An ASCII value.
CHR(65) → 'A'
The INITCAP function forces a string or column to be ...
Read now
Unlock full access