Horton

Remove factorial operators, leaving only the factorial() function.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 76f412ab310554acb970a0b73c8d1f37f35548c6
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2020-09-17T20:17:27Z
Releases: 14.0 
Remove factorial operators, leaving only the factorial() function.

The "!" operator is our only built-in postfix operator.  Remove it,
on the way to removal of grammar support for postfix operators.

There is also a "!!" prefix operator, but since it's been marked
deprecated for most of its existence, we might as well remove it too.

Also zap the SQL alias function numeric_fac(), which seems to have
equally little reason to live.

Mark Dilger, based on work by myself and Robert Haas;
review by John Naylor

Discussion: https://postgr.es/m/38ca86db-42ab-9b48-2902-337a0d6b8311@2ndquadrant.com

Files

PathChange+/−
contrib/postgres_fdw/expected/postgres_fdw.out modified +0 −8
contrib/postgres_fdw/sql/postgres_fdw.sql modified +0 −1
doc/src/sgml/func.sgml modified +0 −30
src/include/catalog/catversion.h modified +1 −2
src/include/catalog/pg_operator.dat modified +0 −6
src/include/catalog/pg_proc.dat modified +0 −4
src/test/regress/expected/create_operator.out modified +10 −10
src/test/regress/expected/numeric.out modified +9 −17
src/test/regress/sql/create_operator.sql modified +10 −10
src/test/regress/sql/numeric.sql modified +3 −5

Documentation touched

Discussion