PostgreSQL
table1:
COLUMN 1:

abcd/12345
dfgsdfgds/564356
dfgsdrf/9876

I want output :
abcd
dfgsdfgds
dfgsdrf



>select left(COLUMN1,position('/' IN COLUMN1) -1) from table1

ERROR: Negative substring length not allowed