Re: NULL concatenation

From: Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: NULL concatenation
Date: 2016-05-12 08:53:52
Message-ID: 573444A0.3050600@manifest.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Wrap the source columns in your line:

txt:= txt1 || txt2 || txt3;

in coalesce() calls

Tim Clarke

On 12/05/16 09:47, Sridhar N Bamandlapally wrote:
> txt:= txt1 || txt2 || txt3;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sridhar N Bamandlapally 2016-05-12 08:57:22 Re: [HACKERS] NULL concatenation
Previous Message Pavel Stehule 2016-05-12 08:52:23 Re: [HACKERS] NULL concatenation

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2016-05-12 08:55:44 Re: Declarative partitioning
Previous Message Pavel Stehule 2016-05-12 08:52:23 Re: [HACKERS] NULL concatenation