Overlay function in PostgreSQL [Resolved]

Posted by Crniranjanraj under PostgreSQL on 10/3/2015 | Points: 10 | Views : 559 | Status : [Member] | Replies : 2
Can anybody please explain me the purpose of Overlay function in PostgreSQL?




Responses

Posted by: Rajnilari2015 on: 10/4/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
The purpose of Overlay function is to : To replace substring from a specified position to a specified position.

e.g.

Select Overlay('www.dotnetanda.com' Placing 'funda' From 11 For 4) "Overlay Example"
/* Result */

Overlay Example
---------------
www.dotnetfunda.com


Full article: http://www.dotnetfunda.com/articles/show/2166/let-us-implement-postgresql39s-overlay-function-in-sql-server-2012

--
Thanks & Regards,
RNA Team

Crniranjanraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Crniranjanraj on: 10/4/2015 [Member] Starter | Points: 25

Up
0
Down
OK, I understand . thanks

Crniranjanraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response