SPACE ( integer_expression ) SPACE(<n>)function SPACE( occurrences ){
return ' '.repeat( occurrences );
}Last updated
SELECT CONCAT('SOME', SPACE(5), 'TEXT') AS RESULT;RESULT |
-------------+
SOME TEXT|SELECT CONCAT('SOME', SPACE(5), 'TEXT') AS RESULT;RESULT |
-------------+
SOME TEXT|CREATE OR REPLACE FUNCTION SPACE(occurrences float)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
function SPACE( occurrences ){
return ' '.repeat( occurrences );
}
return SPACE( OCCURRENCES );
$$;
SELECT CONCAT('SOME', SPACE(5), 'TEXT') RESULT;RESULT |
-------------+
SOME TEXT|