3 ms·
postgres=# SELECT AVG(x) FROM (SELECT 1 AS x UNION SELECT NULL) t; avg ------------------------ 1.00000000000000000000 (1
by dllthomas 9y ago
postgres=# SELECT AVG(x) FROM (SELECT 1 AS x UNION SELECT NULL) t;
avg
------------------------
1.00000000000000000000
(1 row)