Re: PL/pgSQL RETURN QUERY and DOMAIN CHECKs

Hello,

can anyone explain why the domain check is not generating an exception
when used within PL/pgSQL ‘RETURN QUERY’ statement?



 45 -- works not as expected:
 46 CREATE OR REPLACE FUNCTION tf2() RETURNS SETOF t
 47 AS $$
 48 DECLARE
 49 BEGIN
 50   RETURN QUERY select 4::double precision, 5::double precision;
 51 END; $$ LANGUAGE plpgsql SECURITY DEFINER;
 52 /*
 53  *** *x=# SELECT tf2();
 54  *** +-------+
 55  *** |  tf2  |
 56  *** +-------+
 57  *** | (4,5) |
 58  *** +-------+
 59  *** (1 row)
 60  ***