On 29/08/2025 12:06, Pavel Stehule wrote:
>
> > I can imagine allowing the NOT NULL flag for functions, and then
> the
> > result can be checked on NOT NULL value.
>
> I like the idea of a NOT NULL flag for functions.
> What syntax could we image for that?
>
>
> CREATE OR REPLACE FUNCTION foo() RETURNS int NOT NULL AS $$ SELECT 10
> $$ LANGUAGE ...
What if the function is supposed to return NULL sometimes? The point
here is not the value but the row count.
--
Vik Fearing