CHR

Converts the first character of an INTEGER datatype to a VARCHAR.

Behavior type

Syntax

CHR ( expression )

Arguments

expression

(INTEGER) is the string to convert and is masked to a single character.

Notes

• CHR is the opposite of the ASCII function.

• CHR operates on UTF-8 characters, not only on single-byte ASCII characters. It continues to get the same results for the ASCII subset of UTF-8.

Examples

This example returns the VARCHAR datatype of the CHR expressions 65 and 97 from the employee table:

=> SELECT CHR(65), CHR(97) FROM employee;
 CHR | CHR
-----+-----
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
 A   | a
(12 rows)