This section describes functions and operators for examining and manipulating values of type
set_bytenumber the first byte of a binary string as byte 0.
set_bitnumber bits from the right within each byte; for example bit 0 is the least significant bit of the first byte, and bit 15 is the most significant bit of the second byte.
Note that for historic reasons, the function
md5returns a hex-encoded value of type
textwhereas the SHA-2 functions return type
bytea. Use the functions
decodeto convert between the two, for example
encode(sha256('abc'), 'hex')to get a hex-encoded text representation.