Postgres 13

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?.

SELECT ARRAY[0.25, 0.5, 0.75]

array

{0.25,0.5,0.75}

SELECT 1

CREATE TABLE t(i INT);

INSERT INTO t VALUES (1),(2),(3),(4);

CREATE TABLE

INSERT 0 4

select 
       percentile_cont(ARRAY[0.25, 0.5, 0.75]) within group (order by i) as q25
from t

q25

{1.75,2.5,3.25}

SELECT 1

select 
       percentile_cont('{0.25, 0.5, 0.75}'::double precision[]) within group (order by i) as q25
from t

q25

{1.75,2.5,3.25}

SELECT 1

WITH cte AS (
  select 
       percentile_cont(ARRAY[0.25, 0.5, 0.75]) within group (order by i) as q
from t
)
SELECT q[1] AS q25, 
       q[2] AS q50,
       q[3] As q75
FROM cte

q25
q50
q75

1.75
2.5
3.25

SELECT 1