diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2023-04-07 11:47:07 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2023-04-07 11:47:07 -0400 |
commit | 888f2ea0a81ff171087bdd1c5c1eeda3b78d73d4 (patch) | |
tree | b596640ca993a5fd85568e173b0a8e48a7d69071 /src/include/catalog/pg_proc.dat | |
parent | cd82e5c79d145dddd7a30ed35e4d3b83945b56f3 (diff) | |
download | postgresql-888f2ea0a81ff171087bdd1c5c1eeda3b78d73d4.tar.gz |
Add array_sample() and array_shuffle() functions.
These are useful in Monte Carlo applications.
Martin Kalcher, reviewed/adjusted by Daniel Gustafsson and myself
Discussion: https://postgr.es/m/9d160a44-7675-51e8-60cf-6d64b76db831@aboutsource.net
Diffstat (limited to 'src/include/catalog/pg_proc.dat')
-rw-r--r-- | src/include/catalog/pg_proc.dat | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat index f9f2642201..f64bc68276 100644 --- a/src/include/catalog/pg_proc.dat +++ b/src/include/catalog/pg_proc.dat @@ -1717,6 +1717,12 @@ { oid => '6172', descr => 'remove last N elements of array', proname => 'trim_array', prorettype => 'anyarray', proargtypes => 'anyarray int4', prosrc => 'trim_array' }, +{ oid => '8464', descr => 'shuffle array', + proname => 'array_shuffle', provolatile => 'v', prorettype => 'anyarray', + proargtypes => 'anyarray', prosrc => 'array_shuffle' }, +{ oid => '8465', descr => 'take samples from array', + proname => 'array_sample', provolatile => 'v', prorettype => 'anyarray', + proargtypes => 'anyarray int4', prosrc => 'array_sample' }, { oid => '3816', descr => 'array typanalyze', proname => 'array_typanalyze', provolatile => 's', prorettype => 'bool', proargtypes => 'internal', prosrc => 'array_typanalyze' }, |