Re: [HACKERS] NULL input for array_agg()?

2009-11-15 Thread Hitoshi Harada
2009/11/15 Andrew Gierth : >> "Hitoshi" == Hitoshi Harada writes: > >  Hitoshi> Hi, During reviewing aggregates ORDER BY, I was reading spec >  Hitoshi> and found description like: > >  Hitoshi> == snip == > >  Hitoshi> Of the rows in the aggregation, the following do not qualify: >  Hitoshi>

Re: [HACKERS] NULL input for array_agg()?

2009-11-14 Thread Andrew Gierth
> "Hitoshi" == Hitoshi Harada writes: Hitoshi> Hi, During reviewing aggregates ORDER BY, I was reading spec Hitoshi> and found description like: Hitoshi> == snip == Hitoshi> Of the rows in the aggregation, the following do not qualify: Hitoshi> — If DISTINCT is specified, then redundan

[HACKERS] NULL input for array_agg()?

2009-11-14 Thread Hitoshi Harada
Hi, During reviewing aggregates ORDER BY, I was reading spec and found description like: == snip == Of the rows in the aggregation, the following do not qualify: — If DISTINCT is specified, then redundant duplicates. — Every row in which the evaluates to the null value. == /snip == ... and ar