On 5/18/20 4:42 PM, Peter Eisentraut wrote: > There have been occasional discussions about deprecating or phasing out > postfix operators, to make various things easier in the parser. > > The first step would in any case be to provide alternatives for the > existing postfix operators. There is currently one, namely the numeric > factorial operator "!". A sensible alternative for that would be > providing a function factorial(numeric) -- and that already exists but > is not documented. (Note that the operator is mapped to proname > "numeric_fac". The function "factorial" maps to the same prosrc but is > otherwise independent of the operator.) > > So I suggest that we add that function to the documentation.
I think this should be done regardless. > (Some adjacent cleanup work might also be in order. The test cases for > factorial are currently in int4.sql, but all the factorial functionality > was moved to numeric a long time ago.) > > What are the thoughts about then marking the postfix operator deprecated > and eventually removing it? I am greatly in favor of removing postfix operators as soon as possible. -- Vik Fearing
