create schema db_space;
set current_schema to 'db_space';
select space('a');
space
-------
(1 row)
select space(10);
space
------------
(1 row)
select space(-1);
space
-------
(1 row)
select space('0');
space
-------
(1 row)
select space('11a');
space
-------------
(1 row)
select space('11.6a');
space
-------------
(1 row)
select space(11.6);
space
--------------
(1 row)
select space(true);
space
-------
(1 row)
select space(1,2,3);
ERROR: function space(integer, integer, integer) does not exist
LINE 1: select space(1,2,3);
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
CONTEXT: referenced column: space
select space(2147483647111);
WARNING: integer out of range
CONTEXT: referenced column: space
space
-------
(1 row)
select space(b'111');
space
---------
(1 row)
drop schema db_space cascade;
reset current_schema;