-- Unlike percentiles passed to tdigest_percentile(), non-finite hypothetical
-- values passed to tdigest_percentile_of() are accepted and mapped to fixed
-- results. Input values stored in the digest must still be finite.
\set VERBOSITY terse
-- hypothetical values map to NaN, 0, and 1, respectively
SELECT tdigest_percentile_of(1.0::double precision, 10, 'NaN'::double precision);
 tdigest_percentile_of 
-----------------------
                   NaN
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 10, '-infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     0
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 10, 'infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     1
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 10, ARRAY['NaN', '-infinity', 'infinity']::double precision[]);
 tdigest_percentile_of 
-----------------------
 {NaN,0,1}
(1 row)

SELECT tdigest_percentile_of('flags 1 count 3 compression 10 centroids 3 (1, 1) (2, 1) (3, 1)'::tdigest,
                             'NaN'::double precision);
 tdigest_percentile_of 
-----------------------
                   NaN
(1 row)

SELECT tdigest_percentile_of('flags 1 count 3 compression 10 centroids 3 (1, 1) (2, 1) (3, 1)'::tdigest,
                             '-infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     0
(1 row)

SELECT tdigest_percentile_of('flags 1 count 3 compression 10 centroids 3 (1, 1) (2, 1) (3, 1)'::tdigest,
                             'infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     1
(1 row)

SELECT tdigest_percentile_of('flags 1 count 3 compression 10 centroids 3 (1, 1) (2, 1) (3, 1)'::tdigest,
                             ARRAY['NaN', '-infinity', 'infinity']::double precision[]);
 tdigest_percentile_of 
-----------------------
 {NaN,0,1}
(1 row)

-- the value/count API has the same handling of non-finite hypothetical values
SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, 'NaN'::double precision);
 tdigest_percentile_of 
-----------------------
                   NaN
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, '-infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     0
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, 'infinity'::double precision);
 tdigest_percentile_of 
-----------------------
                     1
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, ARRAY['NaN']::double precision[]);
 tdigest_percentile_of 
-----------------------
 {NaN}
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, ARRAY['-infinity']::double precision[]);
 tdigest_percentile_of 
-----------------------
 {0}
(1 row)

SELECT tdigest_percentile_of(1.0::double precision, 2::bigint, 10, ARRAY['infinity']::double precision[]);
 tdigest_percentile_of 
-----------------------
 {1}
(1 row)