| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: factorial function/phase out postfix operators? |
| Date: | 2020-08-27 14:19:21 |
| Message-ID: | CA+TgmoYpMDnShwTgWmYsDFV6daETuC3au_GCTr6yKBoQHpj_uA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 27, 2020 at 10:04 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rémi Lapeyre | 2020-08-27 14:53:11 | Re: Add header support to text format and matching feature |
| Previous Message | Mark Dilger | 2020-08-27 14:14:26 | Re: factorial function/phase out postfix operators? |