summaryrefslogtreecommitdiff
path: root/src/include/catalog/pg_proc.dat
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2022-12-24 13:18:35 +1300
committerDavid Rowley <drowley@postgresql.org>2022-12-24 13:18:35 +1300
commitb5aff9255700b0b3155a4d2be865b6a776c2bda4 (patch)
treee37e34d45f5e304bd2852555a945bdd12a001068 /src/include/catalog/pg_proc.dat
parentc6f21b2ac215ad870a95159ea22024f734429622 (diff)
downloadpostgresql-b5aff9255700b0b3155a4d2be865b6a776c2bda4.tar.gz
Fix recent accidental omission in pg_proc.dat
ed1a88dda added support functions for the ntile(), percent_rank() and cume_dist() window functions but neglected to actually add these support functions to the pg_proc entry for the corresponding window function. Also, take this opportunity to add these window functions to one of the regression tests added in ed1a88dda to give the support functions a little bit of exercise. If I'd done that in the first place then the omission would have been more obvious. Bump the catversion, again.
Diffstat (limited to 'src/include/catalog/pg_proc.dat')
-rw-r--r--src/include/catalog/pg_proc.dat14
1 files changed, 8 insertions, 6 deletions
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat
index 88bd472ecd..7056c95371 100644
--- a/src/include/catalog/pg_proc.dat
+++ b/src/include/catalog/pg_proc.dat
@@ -10204,20 +10204,22 @@
proname => 'window_dense_rank_support', prorettype => 'internal',
proargtypes => 'internal', prosrc => 'window_dense_rank_support' },
{ oid => '3103', descr => 'fractional rank within partition',
- proname => 'percent_rank', prokind => 'w', proisstrict => 'f',
- prorettype => 'float8', proargtypes => '', prosrc => 'window_percent_rank' },
+ proname => 'percent_rank', prosupport => 'window_percent_rank_support',
+ prokind => 'w', proisstrict => 'f', prorettype => 'float8',
+ proargtypes => '', prosrc => 'window_percent_rank' },
{ oid => '9773', descr => 'planner support for percent_rank',
proname => 'window_percent_rank_support', prorettype => 'internal',
proargtypes => 'internal', prosrc => 'window_percent_rank_support' },
{ oid => '3104', descr => 'fractional row number within partition',
- proname => 'cume_dist', prokind => 'w', proisstrict => 'f',
- prorettype => 'float8', proargtypes => '', prosrc => 'window_cume_dist' },
+ proname => 'cume_dist', prosupport => 'window_cume_dist_support',
+ prokind => 'w', proisstrict => 'f', prorettype => 'float8',
+ proargtypes => '', prosrc => 'window_cume_dist' },
{ oid => '9774', descr => 'planner support for cume_dist',
proname => 'window_cume_dist_support', prorettype => 'internal',
proargtypes => 'internal', prosrc => 'window_cume_dist_support' },
{ oid => '3105', descr => 'split rows into N groups',
- proname => 'ntile', prokind => 'w', prorettype => 'int4',
- proargtypes => 'int4', prosrc => 'window_ntile' },
+ proname => 'ntile', prosupport => 'window_ntile_support', prokind => 'w',
+ prorettype => 'int4', proargtypes => 'int4', prosrc => 'window_ntile' },
{ oid => '9775', descr => 'planner support for ntile',
proname => 'window_ntile_support', prorettype => 'internal',
proargtypes => 'internal', prosrc => 'window_ntile_support' },