Re: [HACKERS] NULL concatenation

Thanks Pavel Great !! I was thinking both || and CANCAT does same Thanks again - Sridhar OpenText On Thu, May 12, 2016 at 2:22 PM, Pavel Stehule wrote: > Hi > > 2016-05-12 10:47 GMT+02:00 Sridhar N Bamandlapally > : > >> Hi >> >> In

Re: [HACKERS] NULL concatenation

Hi 2016-05-12 10:47 GMT+02:00 Sridhar N Bamandlapally : > Hi > > In migration, am facing issue with NULL concatenation in plpgsql, > by concatenating NULL between any where/position to Text / Varchar, the > total string result is setting value to NULL > > > *In Oracle:* >

[HACKERS] NULL concatenation

Hi In migration, am facing issue with NULL concatenation in plpgsql, by concatenating NULL between any where/position to Text / Varchar, the total string result is setting value to NULL *In Oracle:* declare txt1 VARCHAR2(100) := 'ABCD'; txt2 VARCHAR2(100) := NULL; txt3