concat()

Scalar. Returns the binary value of the concatenation of two given binary values.

Syntax

concat ( binary1, binary2 )

Parameters

binary1

A binary value
binary2

A binary value

Usage

The function returns a binary value. The function returns NULL if either argument is NULL.

Example

concat ( hex_binary ('aabbcc'), hex_binary ('ddeeff') ) returns AABBCCDDEEFF.

concat ( hex_binary ('ddeeff'), hex_binary ('aabbcc') )returns DDEEFFAABBCC.