Re: Operator is not unique
| От | Tom Lane |
|---|---|
| Тема | Re: Operator is not unique |
| Дата | |
| Msg-id | 26283.1569855255@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: Operator is not unique (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> The list of extensions that you sent earlier are fairly common. I would
> not expect them to be contributing to the below otherwise there would
> have been more reports of what you are seeing.
A quick "grep" shows that there is nothing named "day_inc" in core
Postgres nor any of the contrib extensions. So this is something
homegrown. It looks to me like somebody wanted a plus operator
that would add numerics and dates/timestamps/timestamptzs, and
figured they could be lazy and make one operator using "anyelement".
But this will capture numeric plus *anything*, so it was not a
good idea. I'd recommend dropping the use of anyelement and just
making three non-polymorphic operators.
regards, tom lane
В списке pgsql-general по дате отправления: