domains, case statements, functions: bug?

From: Joe Van Dyk <joe(at)tanga(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: domains, case statements, functions: bug?
Date: 2013-07-08 17:26:19
Message-ID: CACfv+pLbohaGYG3RznncioppAWosJ_pt357rGmeRS2bZ-3U5ZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create domain m numeric(5,2);
create table t (c m);
create function f(t) returns m as $ select case when true then $1.c end $
language sql;

psql:/tmp/t1.sql:3: ERROR: return type mismatch in function declared to
return m
DETAIL: Actual return type is numeric.
CONTEXT: SQL function "f"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2013-07-08 19:20:44 Dump/Reload pg_statistic to cut time from pg_upgrade?
Previous Message Jeff Davis 2013-07-08 17:16:15 Re: Why is NULL = unbounded for rangetypes?