Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. - Mailing list pgsql-bugs

From Merlin Moncure
Subject Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
Date
Msg-id b42b73150909010939t4a27cae0s934f7b7a0805229e@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
On Tue, Sep 1, 2009 at 4:11 AM, Heikki
Linnakangas<heikki.linnakangas@enterprisedb.com> wrote:
> 2. The semantics of STRICT with row arguments is broken. It should be
> made consistent with IS NULL. Strict function should not be called if
> the argument is a row value with all NULL columns.

not just STRICT, but coalesce(), libpq 'is null' bit, plpgsql row
variables, type input/output, joins, etc.  see recent threads on
-hackers and -bugs note that fixing this would break code in the field
(like mine for example) :-).

merlin

pgsql-bugs by date:

Previous
From: "Joseph Shraibman"
Date:
Subject: BUG #5028: CASE returns ELSE value always when type is "char"
Next
From: Sam Mason
Date:
Subject: Re: BUG #5028: CASE returns ELSE value always when type is "char"