Oracle "replace" function alternative in PostgreSQL with 2 arguments?

Question

Select REPLACE('123123tech', '123')
  From Dual;

Above is Oracle code but when I am going to find its alternative in PostgreSQL can't find a suitable function for that. PostgreSQL REPLACE function takes 3 arguments. I want a function who can take 2 arguments. Any solution ?

Oracle's REPLACE function also takes three arguments but the third is optional, which means that in your case, you want to remove the characters 123 from the source string. PostgreSQL has the same function but the third argument is not optional. So, as far as I can tell, there is no 2 argument function solution for you. — Abra
– Abra, Commented Feb 18, 2020 at 8:05

Bjarni Ragnarsson · Accepted Answer · 2020-02-18 07:57:52Z

1

The way to do this in Postgresql is Select REPLACE('123123tech', '123','').

Best regards,
Bjarni

answered Feb 18, 2020 at 7:57

Bjarni Ragnarsson

1,7811 gold badge8 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Oracle "replace" function alternative in PostgreSQL with 2 arguments?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related