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.
> 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 ...
> 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?
What if the function is supposed to return NULL sometimes? The point here is not the value but the row count.
-- Vik Fearing
--
Vik Fearing
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных
