Re: Assert single row returning SQL-standard functions

> 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