I tried to enter invalid percentile fractions, and was astonished that it seems to be checked after many work is done?

psql (11devel)
Type "help" for help.

jotpe=# \timing
Timing is on.
jotpe=# select percentile_cont(array[0,0.25,0.5,1,1,null,2]) within group(order by txk) from klima_tag;
ERROR:  percentile value 2 is not between 0 and 1
Time: 19155,565 ms (00:19,156)
jotpe=# select count(*) from klima_tag;
  count
----------
 13950214
(1 row)

Time: 933,847 ms


Best regards Johannes

Reply via email to