Sandro Santilli <strk@keybit.net> writes:
> The same happens with any type, can be reproduced with something like this:
> =# CREATE VIEW test1 AS SELECT
> CASE WHEN random() < 0.5 THEN 1::numeric(10, 0)
> END;
> =# \d test1
> View "test.test1"
> Column | Type | Modifiers
> --------+---------+-----------
> case | numeric |
> =# CREATE VIEW test2 AS SELECT
> CASE WHEN random() < 0.5 THEN 1::numeric(10, 0)
> ELSE 0::numeric(10, 0)
> END;
> =# \d test2
> View "test.test2"
> Column | Type | Modifiers
> --------+---------------+-----------
> case | numeric(10,0) |
> Maybe someone on pgsql-hackers can tell us more about this.
IIRC, the result of a CASE is only considered to have a defined typmod
if all arms of the CASE ... including ELSE ... have the identical
typmod.
regards, tom lane