Ah yeah, the concatenation. I was thinking of using "+" but I can't make it work and the documentation says not to use it for psycopg2.
Sorry what's bottom-post? I see you did that yesterday. Is there a format for before making a bottom-post? On Wed, May 16, 2018 at 11:04 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, May 15, 2018, tango ward <tangowar...@gmail.com> wrote: > >> Sorry for bumping this email. >> >> I would just like to clarify regarding regexp_replace: >> >> WHEN mobilenumber ~'^9[0-9]' AND LENGTH(mobilenumber) = 10 >> THEN regexp_replace(mobilenumber, '', '+63') >> >> If the pattern is empty '', does this mean that the replacement_string >> param will be added to the value of source? It does what I want it to do >> but I am not sure if that's always the case if pattern param is empty. >> > > If you could bottom-post like the rest of us that would be helpful. > > While that seems to work it is definitely obscure. You should just use > concatenation. > > ’+63' || mobilenumber > > The pattern is a zero-length string, matched once, which first matches the > start of the input text. Not sure what happens when the input is the empty > string... > > David J. >
