Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3884
Home > Forums > PostgreSQL >

Overlay function in PostgreSQL [Resolved]

Posted by Crniranjanraj under PostgreSQL on 10/3/2015 | Points: 10 | Views : 2674 | Status : [Member] | Replies : 2
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
Can anybody please explain me the purpose of Overlay function in PostgreSQL?



Reply | Reply with Attachment
Alert Moderator 

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

Latest Posts