Re: [HACKERS] WIP json generation enhancements : strange IS NULL behaviour

2012-11-26 Thread Tom Lane
Hannu Krosing writes: > On 11/26/2012 09:05 PM, Tom Lane wrote: >> The analogy to other aggregates is probably a better thing to argue >> from. On the other hand, I don't know anyone outside the SQL standards >> committee who thinks it's actually a good idea that SUM() across no rows >> returns n

Re: [HACKERS] WIP json generation enhancements : strange IS NULL behaviour

2012-11-26 Thread Hannu Krosing
On 11/26/2012 09:05 PM, Tom Lane wrote: Hannu Krosing writes: In some previous mail Tom Lane claimed that by SQL standard either an array of all NULLs or a record with all fields NULLs (I don't remember which) is also considered NULL. If this is true, then an empty array - which can be said to