Sandro Santilli <s...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers