pá 29. 8. 2025 v 15:47 odesílatel Vik Fearing <v...@postgresfriends.org> napsal:
> > 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. > yes, it doesn't 100% cover Joel's proposal. It can work for naturally NOT NULL domains only. > -- > > Vik Fearing >
