Add a string to a specific location in Postgres

Question

I need to add a dot in the 4th position of each string in a column. How can I perform this in Postgres?

Example: '1234' should become '123.4'

sokoli · Accepted Answer · 2016-09-26 08:56:58Z

4

For example use left / right:

db=> select left('1234', 3) || '.' || right('1234', -3);
 ?column? 
----------
 123.4

answered Sep 26, 2016 at 8:56

sokoli

5153 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Worked! Thank you.