[Firebird-devel] minvalue & maxvalue

[Claudio V. C. <cv...@us...>]

Hello, are MINVALUE and MAXVALUE in the standard?

SQL> select maxvalue(0, null) from rdb$database;

    MAXVALUE
============
      <null>

I was thinking that it would be more useful if we act as MAX/AVG that only
return NULL if all values inspected are NULL:
maxvalue(NULL) -> NULL
maxvalue(NULL, 0) -> 0
maxvalue(NULL, 0, NULL, 3) -> 3

etc. Opinions?

C.
---
Claudio Valderrama C. - www.cvalde.net
Consultant, SW developer.