On Thu, Aug 27, 2020 at 10:04 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Well, the !! operator itself has been "deprecated" for a long time: > > regression=# \do+ !! > List of operators > Schema | Name | Left arg type | Right arg type | Result type | Function > | Description > ------------+------+---------------+----------------+-------------+-------------+--------------------------- > pg_catalog | !! | | bigint | numeric | > numeric_fac | deprecated, use ! instead > pg_catalog | !! | | tsquery | tsquery | > tsquery_not | NOT tsquery > (2 rows) > > I'm a bit inclined to kill them both off and standardize on factorial() > (not numeric_fac).
Works for me. !! hasn't been marked as deprecated in the documentation, only the operator comment, which probably not many people look at. But I don't see a problem updating the documentation now to say: - !! is going away, use factorial() - ! is going away, use factorial() - postfix operators are going away -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company