Re: Failure to coerce unknown type to specific type

Kevin Grittner <kgrittn@ymail.com> wrote:

> The spec section 6.11 1) c) very explicitly requires
>   COALESCE(NULL, NULL)
> be the exact equivalent of
>   CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END
>
> Yet in PostgreSQL the long form of the CASE clause returns the
> same thing as a bare NULL, while the short form (COALESCE) gives
> an error.

Never mind; I got confused in my testing -- they both return NULL
of type text.  I'll dig on that one some more.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company