On 1 February 2010 13:40, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2010/2/1 Thom Brown <thombrown(at)gmail(dot)com>:
> > I noticed that the regression test results don't include the following
> > select string_agg(a) from (values(null),(null)) g(a);
> > There is one similar where a delimiter is provided.
> > Which leads me to ask for clarification, would it be safe to assume that
> > string_agg can never itself return null?
> if all values are null, then result is null.
Ah, I was looking at the expected results, and couldn't see a NULL outcome,
but then these aren't indicated in such results anyway.
In response to
pgsql-hackers by date
|Next:||From: Magnus Hagander||Date: 2010-02-01 14:03:52|
|Subject: Re: mailing list archiver chewing patches|
|Previous:||From: Pavel Stehule||Date: 2010-02-01 13:40:50|
|Subject: Re: Review: listagg aggregate|