Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE OR REPLACE AGGREGATE median (anyelement)
( SFUNC = array_append
, STYPE = anyarray
, INITCOND = '{}'
) ;

ERROR:  function array_append(anyarray, anyelement) does not exist

SELECT median(x.y) FROM (VALUES (1),(2),(3),(4),(5)) AS x(y)

ERROR:  function median(integer) does not exist
LINE 1: SELECT median(x.y) FROM (VALUES (1),(2),(3),(4),(5)) AS x(y)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

CREATE OR REPLACE AGGREGATE median (anycompatible)
( SFUNC = array_append
, STYPE = anycompatiblearray
, INITCOND = '{}'
) ;

CREATE AGGREGATE

SELECT median(x.y) FROM (VALUES (1),(2),(3),(4),(5)) AS x(y)

median

{1,2,3,4,5}

SELECT 1