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
