Postgres 17

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select split_part('abc', ':', 1);

split_part

abc

SELECT 1

select split_part('abc', ':', 0);

ERROR:  field position must not be zero

select split_part('abc', ':', -1);

split_part

abc

SELECT 1