Home > mailing lists

Re: Sum of columns - Mailing list pgsql-general

From	BladeOfLight16
Subject	Re: Sum of columns
Date	September 13, 2013 02:58:57
Msg-id	CA+=1U=U7vQ1rXr4mqEttjXQRVw0iyC8b19epfKTmGQBJTATccQ@mail.gmail.com Whole thread Raw
In response to	Re: Sum of columns (Marc Mamin <M.Mamin@intershop.de>)
List	pgsql-general

On Mon, Sep 9, 2013 at 8:12 AM, Marc Mamin <M.Mamin@intershop.de> wrote:

hi,
in addition to the others comments, you can also remove " ELSE 0 " from your query.
It will result in <NULL> values that are discarded by SUM.

From: David Johnston
Date: 13 September 2013, 01:57:43
Subject: Re: problem with query

From: Chris Travers
Date: 13 September 2013, 03:25:33
Subject: Re: Best way to populate nested composite type from JSON`