SPACE
Returns the specified number of blank spaces, typically for insertion into a character string.
Behavior Type
Syntax
SPACE(n)
Parameters
n |
An integer argument that specifies how many spaces to insert. |
Example
The following example concatenates strings x
and y
with 10 spaces inserted between them:
=> SELECT 'x' || SPACE(10) || 'y' AS Ten_spaces; Ten_spaces -------------- x y (1 row)