Re: array_agg() NULL Handling
От
Thom Brown
Тема
Re: array_agg() NULL Handling
Дата
Msg-id
AANLkTikOynn0Hh-19+H6MeR0MsT1h3Yk3vHCfZDXQZBV@mail.gmail.com
Ответ на
Re: array_agg() NULL Handling (David Fetter)
Список
Дерево обсуждения
array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Pavel Stehule <pavel.stehule@gmail.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling David Fetter <david@fetter.org>
Re: array_agg() NULL Handling Thom Brown <thom@linux.com>
Re: array_agg() NULL Handling Pavel Stehule <pavel.stehule@gmail.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Tom Lane <tgl@sss.pgh.pa.us>
Re: array_agg() NULL Handling Pavel Stehule <pavel.stehule@gmail.com>
Re: array_agg() NULL Handling Tom Lane <tgl@sss.pgh.pa.us>
Re: array_agg() NULL Handling Pavel Stehule <pavel.stehule@gmail.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Dimitri Fontaine <dfontaine@hi-media.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Tom Lane <tgl@sss.pgh.pa.us>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Tom Lane <tgl@sss.pgh.pa.us>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Tom Lane <tgl@sss.pgh.pa.us>
Re: array_agg() NULL Handling Thom Brown <thom@linux.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
Re: array_agg() NULL Handling Thom Brown <thom@linux.com>
Re: array_agg() NULL Handling "David E. Wheeler" <david@kineticode.com>
On 1 September 2010 18:47, David Fetter wrote: > On Wed, Sep 01, 2010 at 08:16:41AM -0700, David Wheeler wrote: >> On Sep 1, 2010, at 12:30 AM, Pavel Stehule wrote: >> >> > Docs is wrong :) I like current implementation. You can remove a >> > NULLs from aggregation very simply, but different direction isn't >> > possible >> >> Would appreciate the recipe for removing the NULLs. > > WHERE clause :P There may be cases where that's undesirable, such as there being more than one aggregate in the SELECT list, or the column being grouped on needing to return rows regardless as to whether there's NULLs in the column being targeted by array_agg() or not. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
В списке pgsql-hackers по дате отправления
