Führende Nullen vor einer Zahl

289

Link Reference

Not set

Link Credits

Not set

Link Technical Documentation

Not set

PlCodelang

PL/pgSQL

PlGroup

Strings

PlItemTitle

Führende Nullen vor einer Zahl

Code

WITH cte_example AS
(
SELECT 5 AS int_example UNION ALL
SELECT 10 AS int_example UNION ALL
SELECT 50 AS int_example
)

SELECT
int_example,
RPAD(int_example::text, 3, '0'),
LPAD(int_example::text, 3, '0')
FROM cte_example

Result Example

int_example	rpad	lpad
5	500	005
10	100	010
50	500	050