Alien-DBD-SQLite-BundledExtensions
view release on metacpan - search on metacpan
view release on metacpan or search on metacpan
lib/DBD/SQLite/BundledExtensions.pm view on Meta::CPAN
(2) If the P argument to percentile(Y,P) is not the same for every
row in the aggregate then an error is thrown. The word "same"
in the previous sentence means that the value differ by less
than 0.001.
(3) If the P argument to percentile(Y,P) evaluates to anything other
than a number in the range of 0.0 to 100.0 inclusive then an
error is thrown.
(4) If any Y argument to percentile(Y,P) evaluates to a value that
is not NULL and is not numeric then an error is thrown.
(5) If any Y argument to percentile(Y,P) evaluates to plus or minus
infinity then an error is thrown. (SQLite always interprets NaN
values as NULL.)
(6) Both Y and P in percentile(Y,P) can be arbitrary expressions,
including CASE WHEN expressions.
(7) The percentile(Y,P) aggregate is able to handle inputs of at least
one million (1,000,000) rows.
(8) If there are no non-NULL values for Y, then percentile(Y,P)
returns NULL.
(9) If there is exactly one non-NULL value for Y, the percentile(Y,P)
returns the one Y value.
(10) If there N non-NULL values of Y where N is two or more and
view all matches for this distributionview release on metacpan - search on metacpan
( run in 0.783 second using v1.00-cache-2.02-grep-82fe00e-cpan-2c419f77a38b )