Aggregates - Cockroach

<table> <thead><tr><th>Function → Returns</th><th>Description</th><th>Volatility</th></tr></thead> <tbody> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="bool.html">bool</a>[]) → <a href="bool.html">bool</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="bytes.html">bytes</a>[]) → <a href="bytes.html">bytes</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="date.html">date</a>) → <a href="date.html">date</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="date.html">date</a>[]) → <a href="date.html">date</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="decimal.html">decimal</a>[]) → <a href="decimal.html">decimal</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="float.html">float</a>[]) → <a href="float.html">float</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="inet.html">inet</a>) → <a href="inet.html">inet</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="inet.html">inet</a>[]) → <a href="inet.html">inet</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="int.html">int</a>[]) → <a href="int.html">int</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="interval.html">interval</a>) → <a href="interval.html">interval</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="interval.html">interval</a>[]) → <a href="interval.html">interval</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="string.html">string</a>) → <a href="string.html">string</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="string.html">string</a>[]) → <a href="string.html">string</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="time.html">time</a>) → <a href="time.html">time</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="time.html">time</a>[]) → <a href="time.html">time</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="timestamp.html">timestamp</a>) → <a href="timestamp.html">timestamp</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="timestamp.html">timestamp</a>[]) → <a href="timestamp.html">timestamp</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="timestamp.html">timestamptz</a>) → <a href="timestamp.html">timestamptz</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="timestamp.html">timestamptz</a>[]) → <a href="timestamp.html">timestamptz</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="uuid.html">uuid</a>) → <a href="uuid.html">uuid</a>[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: <a href="uuid.html">uuid</a>[]) → <a href="uuid.html">uuid</a>[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: anyenum) → anyenum[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: anyenum[]) → anyenum[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: box2d) → box2d[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: box2d[]) → box2d[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: geography) → geography[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: geography[]) → geography[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: geometry) → geometry[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: geometry[]) → geometry[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: jsonb) → jsonb[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: jsonb[]) → jsonb[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: ltree) → ltree[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: ltree[]) → ltree[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: oid) → oid[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: oid[]) → oid[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: pg_lsn) → pg_lsn[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: pg_lsn[]) → pg_lsn[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: refcursor) → refcursor[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: refcursor[]) → refcursor[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: timetz) → timetz[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: timetz[]) → timetz[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: tuple) → tuple[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: tuple[]) → tuple[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: varbit) → varbit[]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_agg"></a><code>array_agg(arg1: varbit[]) → varbit[][]</code></td><td>Aggregates the selected values into an array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="bool.html">bool</a>[]) → <a href="bool.html">bool</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="bytes.html">bytes</a>[]) → <a href="bytes.html">bytes</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="date.html">date</a>[]) → <a href="date.html">date</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="decimal.html">decimal</a>[]) → <a href="decimal.html">decimal</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="float.html">float</a>[]) → <a href="float.html">float</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="inet.html">inet</a>[]) → <a href="inet.html">inet</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="int.html">int</a>[]) → <a href="int.html">int</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="interval.html">interval</a>[]) → <a href="interval.html">interval</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="string.html">string</a>[]) → <a href="string.html">string</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="time.html">time</a>[]) → <a href="time.html">time</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="timestamp.html">timestamp</a>[]) → <a href="timestamp.html">timestamp</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="timestamp.html">timestamptz</a>[]) → <a href="timestamp.html">timestamptz</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: <a href="uuid.html">uuid</a>[]) → <a href="uuid.html">uuid</a>[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: anyenum[]) → anyenum[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: box2d[]) → box2d[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: geography[]) → geography[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: geometry[]) → geometry[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: jsonb[]) → jsonb[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: ltree[]) → ltree[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: oid[]) → oid[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: pg_lsn[]) → pg_lsn[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: refcursor[]) → refcursor[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: timetz[]) → timetz[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: tuple[]) → tuple[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="array_cat_agg"></a><code>array_cat_agg(arg1: varbit[]) → varbit[]</code></td><td>Unnests the selected arrays into elements that are then aggregated into a single array. </td><td>Immutable</td></tr> <tr><td><a name="avg"></a><code>avg(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the average of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="avg"></a><code>avg(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="avg"></a><code>avg(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the average of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="avg"></a><code>avg(arg1: <a href="interval.html">interval</a>) → <a href="interval.html">interval</a></code></td><td>Calculates the average of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="bit_and"></a><code>bit_and(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates the bitwise AND of all non-null input values, or null if none. </td><td>Immutable</td></tr> <tr><td><a name="bit_and"></a><code>bit_and(arg1: varbit) → varbit</code></td><td>Calculates the bitwise AND of all non-null input values, or null if none. </td><td>Immutable</td></tr> <tr><td><a name="bit_or"></a><code>bit_or(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates the bitwise OR of all non-null input values, or null if none. </td><td>Immutable</td></tr> <tr><td><a name="bit_or"></a><code>bit_or(arg1: varbit) → varbit</code></td><td>Calculates the bitwise OR of all non-null input values, or null if none. </td><td>Immutable</td></tr> <tr><td><a name="bool_and"></a><code>bool_and(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a></code></td><td>Calculates the boolean value of <code>AND</code>ing all selected values. </td><td>Immutable</td></tr> <tr><td><a name="bool_or"></a><code>bool_or(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a></code></td><td>Calculates the boolean value of <code>OR</code>ing all selected values. </td><td>Immutable</td></tr> <tr><td><a name="concat_agg"></a><code>concat_agg(arg1: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a></code></td><td>Concatenates all selected values. </td><td>Immutable</td></tr> <tr><td><a name="concat_agg"></a><code>concat_agg(arg1: <a href="string.html">string</a>) → <a href="string.html">string</a></code></td><td>Concatenates all selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="corr"></a><code>corr(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the correlation coefficient of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="count"></a><code>count(arg1: anyelement) → <a href="int.html">int</a></code></td><td>Calculates the number of selected elements. </td><td>Immutable</td></tr> <tr><td><a name="count_rows"></a><code>count_rows() → <a href="int.html">int</a></code></td><td>Calculates the number of rows. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_pop"></a><code>covar_pop(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the population covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="covar_samp"></a><code>covar_samp(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the sample covariance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="every"></a><code>every(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a></code></td><td>Calculates the boolean value of <code>AND</code>ing all selected values. </td><td>Immutable</td></tr> <tr><td><a name="json_agg"></a><code>json_agg(arg1: anyelement) → jsonb</code></td><td>Aggregates values as a JSON or JSONB array. </td><td>Stable</td></tr> <tr><td><a name="json_object_agg"></a><code>json_object_agg(arg1: <a href="string.html">string</a>, arg2: anyelement) → jsonb</code></td><td>Aggregates values as a JSON or JSONB object. </td><td>Stable</td></tr> <tr><td><a name="jsonb_agg"></a><code>jsonb_agg(arg1: anyelement) → jsonb</code></td><td>Aggregates values as a JSON or JSONB array. </td><td>Stable</td></tr> <tr><td><a name="jsonb_object_agg"></a><code>jsonb_object_agg(arg1: <a href="string.html">string</a>, arg2: anyelement) → jsonb</code></td><td>Aggregates values as a JSON or JSONB object. </td><td>Stable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="date.html">date</a>) → <a href="date.html">date</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="inet.html">inet</a>) → <a href="inet.html">inet</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="interval.html">interval</a>) → <a href="interval.html">interval</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="string.html">string</a>) → <a href="string.html">string</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="time.html">time</a>) → <a href="time.html">time</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="timestamp.html">timestamp</a>) → <a href="timestamp.html">timestamp</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="timestamp.html">timestamptz</a>) → <a href="timestamp.html">timestamptz</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: <a href="uuid.html">uuid</a>) → <a href="uuid.html">uuid</a></code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: anyenum) → anyenum</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: box2d) → box2d</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: collatedstring{*}) → collatedstring{*}</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: geography) → geography</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: geometry) → geometry</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: jsonb) → jsonb</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: ltree) → ltree</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: oid) → oid</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: pg_lsn) → pg_lsn</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: timetz) → timetz</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="max"></a><code>max(arg1: varbit) → varbit</code></td><td>Identifies the maximum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="bool.html">bool</a>) → <a href="bool.html">bool</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="date.html">date</a>) → <a href="date.html">date</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="inet.html">inet</a>) → <a href="inet.html">inet</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="interval.html">interval</a>) → <a href="interval.html">interval</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="string.html">string</a>) → <a href="string.html">string</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="time.html">time</a>) → <a href="time.html">time</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="timestamp.html">timestamp</a>) → <a href="timestamp.html">timestamp</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="timestamp.html">timestamptz</a>) → <a href="timestamp.html">timestamptz</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: <a href="uuid.html">uuid</a>) → <a href="uuid.html">uuid</a></code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: anyenum) → anyenum</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: box2d) → box2d</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: collatedstring{*}) → collatedstring{*}</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: geography) → geography</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: geometry) → geometry</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: jsonb) → jsonb</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: ltree) → ltree</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: oid) → oid</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: pg_lsn) → pg_lsn</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: timetz) → timetz</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="min"></a><code>min(arg1: varbit) → varbit</code></td><td>Identifies the minimum selected value. </td><td>Immutable</td></tr> <tr><td><a name="percentile_cont"></a><code>percentile_cont(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Continuous percentile: returns a float corresponding to the specified fraction in the ordering, interpolating between adjacent input floats if needed. </td><td>Immutable</td></tr> <tr><td><a name="percentile_cont"></a><code>percentile_cont(arg1: <a href="float.html">float</a>) → <a href="interval.html">interval</a></code></td><td>Continuous percentile: returns an interval corresponding to the specified fraction in the ordering, interpolating between adjacent input intervals if needed. </td><td>Immutable</td></tr> <tr><td><a name="percentile_cont"></a><code>percentile_cont(arg1: <a href="float.html">float</a>[]) → <a href="float.html">float</a>[]</code></td><td>Continuous percentile: returns floats corresponding to the specified fractions in the ordering, interpolating between adjacent input floats if needed. </td><td>Immutable</td></tr> <tr><td><a name="percentile_cont"></a><code>percentile_cont(arg1: <a href="float.html">float</a>[]) → <a href="interval.html">interval</a>[]</code></td><td>Continuous percentile: returns intervals corresponding to the specified fractions in the ordering, interpolating between adjacent input intervals if needed. </td><td>Immutable</td></tr> <tr><td><a name="percentile_disc"></a><code>percentile_disc(arg1: <a href="float.html">float</a>) → anyelement</code></td><td>Discrete percentile: returns the first input value whose position in the ordering equals or exceeds the specified fraction. </td><td>Immutable</td></tr> <tr><td><a name="percentile_disc"></a><code>percentile_disc(arg1: <a href="float.html">float</a>[]) → anyelement</code></td><td>Discrete percentile: returns input values whose position in the ordering equals or exceeds the specified fractions. </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgx"></a><code>regr_avgx(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the independent variable (sum(X)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_avgy"></a><code>regr_avgy(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates the average of the dependent variable (sum(Y)/N). </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_count"></a><code>regr_count(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates number of input rows in which both expressions are nonnull. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_intercept"></a><code>regr_intercept(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_r2"></a><code>regr_r2(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates square of the correlation coefficient. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_slope"></a><code>regr_slope(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxx"></a><code>regr_sxx(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the independent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_sxy"></a><code>regr_sxy(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of products of independent times dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="decimal.html">decimal</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="float.html">float</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="float.html">float</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="float.html">float</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="int.html">int</a>, arg2: <a href="decimal.html">decimal</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="int.html">int</a>, arg2: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="regr_syy"></a><code>regr_syy(arg1: <a href="int.html">int</a>, arg2: <a href="int.html">int</a>) → <a href="float.html">float</a></code></td><td>Calculates sum of squares of the dependent variable. </td><td>Immutable</td></tr> <tr><td><a name="sqrdiff"></a><code>sqrdiff(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the sum of squared differences from the mean of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sqrdiff"></a><code>sqrdiff(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the sum of squared differences from the mean of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sqrdiff"></a><code>sqrdiff(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the sum of squared differences from the mean of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="st_asmvt"></a><code>st_asmvt(arg1: tuple) → <a href="bytes.html">bytes</a></code></td><td>Generates a Mapbox Vector Tile (MVT) representation of a set of rows. Uses default layer name ‘default’ and extent 4096. Expects a geometry column named ‘geom’ in the input rows. </td><td>Immutable</td></tr> <tr><td><a name="st_asmvt"></a><code>st_asmvt(arg1: tuple, arg2: <a href="string.html">string</a>) → <a href="bytes.html">bytes</a></code></td><td>Generates a Mapbox Vector Tile (MVT) representation of a set of rows with the specified layer name. Uses extent 4096 and expects a geometry column named ‘geom’ in the input rows. </td><td>Immutable</td></tr> <tr><td><a name="st_asmvt"></a><code>st_asmvt(arg1: tuple, arg2: <a href="string.html">string</a>, arg3: <a href="int.html">int</a>) → <a href="bytes.html">bytes</a></code></td><td>Generates a Mapbox Vector Tile (MVT) representation of a set of rows with the specified layer name and extent. Expects a geometry column named ‘geom’ in the input rows. </td><td>Immutable</td></tr> <tr><td><a name="st_asmvt"></a><code>st_asmvt(arg1: tuple, arg2: <a href="string.html">string</a>, arg3: <a href="int.html">int</a>, arg4: <a href="string.html">string</a>) → <a href="bytes.html">bytes</a></code></td><td>Generates a Mapbox Vector Tile (MVT) representation of a set of rows with the specified layer name, extent, and geometry column name. </td><td>Immutable</td></tr> <tr><td><a name="st_asmvt"></a><code>st_asmvt(arg1: tuple, arg2: <a href="string.html">string</a>, arg3: <a href="int.html">int</a>, arg4: <a href="string.html">string</a>, arg5: <a href="string.html">string</a>) → <a href="bytes.html">bytes</a></code></td><td>Generates a Mapbox Vector Tile (MVT) representation of a set of rows with the specified layer name, extent, geometry column name, and feature ID column name. </td><td>Immutable</td></tr> <tr><td><a name="st_collect"></a><code>st_collect(arg1: geometry) → geometry</code></td><td>Collects geometries into a GeometryCollection or multi-type as appropriate. </td><td>Immutable</td></tr> <tr><td><a name="st_extent"></a><code>st_extent(arg1: geometry) → box2d</code></td><td>Forms a Box2D that encapsulates all provided geometries. </td><td>Immutable</td></tr> <tr><td><a name="st_makeline"></a><code>st_makeline(arg1: geometry) → geometry</code></td><td>Forms a LineString from Point, MultiPoint or LineStrings. Other shapes will be ignored. </td><td>Immutable</td></tr> <tr><td><a name="st_memcollect"></a><code>st_memcollect(arg1: geometry) → geometry</code></td><td>Collects geometries into a GeometryCollection or multi-type as appropriate. </td><td>Immutable</td></tr> <tr><td><a name="st_memunion"></a><code>st_memunion(arg1: geometry) → geometry</code></td><td>Applies a spatial union to the geometries provided. </td><td>Immutable</td></tr> <tr><td><a name="st_union"></a><code>st_union(arg1: geometry) → geometry</code></td><td>Applies a spatial union to the geometries provided. </td><td>Immutable</td></tr> <tr><td><a name="stddev"></a><code>stddev(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev"></a><code>stddev(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev"></a><code>stddev(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_pop"></a><code>stddev_pop(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the population standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_pop"></a><code>stddev_pop(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the population standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_pop"></a><code>stddev_pop(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the population standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_samp"></a><code>stddev_samp(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_samp"></a><code>stddev_samp(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="stddev_samp"></a><code>stddev_samp(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the standard deviation of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="string_agg"></a><code>string_agg(arg1: <a href="bytes.html">bytes</a>, arg2: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a></code></td><td>Concatenates all selected values using the provided delimiter. </td><td>Immutable</td></tr> <tr><td><a name="string_agg"></a><code>string_agg(arg1: <a href="string.html">string</a>, arg2: <a href="string.html">string</a>) → <a href="string.html">string</a></code></td><td>Concatenates all selected values using the provided delimiter. </td><td>Immutable</td></tr> <tr><td><a name="sum"></a><code>sum(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the sum of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sum"></a><code>sum(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the sum of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sum"></a><code>sum(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the sum of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sum"></a><code>sum(arg1: <a href="interval.html">interval</a>) → <a href="interval.html">interval</a></code></td><td>Calculates the sum of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="sum_int"></a><code>sum_int(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates the sum of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_pop"></a><code>var_pop(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the population variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_pop"></a><code>var_pop(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the population variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_pop"></a><code>var_pop(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the population variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_samp"></a><code>var_samp(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_samp"></a><code>var_samp(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="var_samp"></a><code>var_samp(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="variance"></a><code>variance(arg1: <a href="decimal.html">decimal</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="variance"></a><code>variance(arg1: <a href="float.html">float</a>) → <a href="float.html">float</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="variance"></a><code>variance(arg1: <a href="int.html">int</a>) → <a href="decimal.html">decimal</a></code></td><td>Calculates the variance of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="xor_agg"></a><code>xor_agg(arg1: <a href="bytes.html">bytes</a>) → <a href="bytes.html">bytes</a></code></td><td>Calculates the bitwise XOR of the selected values. </td><td>Immutable</td></tr> <tr><td><a name="xor_agg"></a><code>xor_agg(arg1: <a href="int.html">int</a>) → <a href="int.html">int</a></code></td><td>Calculates the bitwise XOR of the selected values. </td><td>Immutable</td></tr></tbody> </table>