Re: multiple paramters in aggregate function - Mailing list pgsql-general

From Sim Zacks
Subject Re: multiple paramters in aggregate function
Date
Msg-id 4A8D41C8.4070804@compulab.co.il
Whole thread Raw
In response to Re: multiple paramters in aggregate function  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: multiple paramters in aggregate function
List pgsql-general
<blockquote cite="mid:20090820122224.GA5532@merkur.hilbert.loc"
 type="cite">

    In other words, I have a conversion table of all different units. If
there is no conversion between 2 units (such as volume and area) then
the sum returns null.



Shouldn't that return NULL IOW unknown ?

Karsten


I am not familiar with returning unknown. I know that according to the
spec an aggregate should only return null if all of its values of the
aggregate are null. If there is a way to return unknown in a non-NULL
way, then that would be preferred.

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: multiple paramters in aggregate function
Next
From: Karsten Hilbert
Date:
Subject: Re: Unit conversion database (was: multiple paramters in aggregate function)