domains, case statements, functions: bug? - Mailing list pgsql-general

From Joe Van Dyk
Subject domains, case statements, functions: bug?
Date
Msg-id CACfv+pLbohaGYG3RznncioppAWosJ_pt357rGmeRS2bZ-3U5ZA@mail.gmail.com
Whole thread Raw
Responses Re: domains, case statements, functions: bug?
List 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"

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Why is NULL = unbounded for rangetypes?
Next
From: Moshe Jacobson
Date:
Subject: Dynamically accessing record elements using EXECUTE