Re: PL/pgSQL RETURN QUERY and DOMAIN CHECKs

On Wed, Aug 23, 2023, 07:25 Christian Barthel <bch(at)online(dot)de> wrote:

> 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 ***
>

The above (and the type definition...) is all that is relevant for the bug
report. Once you've gotten a value of some type nothing else in the system
that is simply passed that value is going to reevaluate the constraints.

David J.

>