Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
Дата
Msg-id CAKFQuwYy2wEd-KZHvXiLM_e5nfTeA17n3fb4gHicq0Pv-KK=qg@mail.gmail.com
обсуждение исходный текст
Ответ на I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database  ("孤傲小二～阿沐" <2903807914@qq.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Nov 11, 2021 at 8:42 PM 孤傲小二～阿沐 <2903807914@qq.com> wrote:
I added a √ operator to scan.l.

Why?
 
The sqrt function is still used internally, but there is a problem now, which affects the := and .. operators of the database.

Someone else will have to volunteer their time to cover this learning curve (I couldn't even if I wanted to).  But given that what you are trying to accomplish is not something we'd likely consider adding to the core server (we created CREATE OPERATOR instead) that seems like a bit of an ask.


# Description of Requirement:
1、select √ num1; function
2、The value of num1 is required to be: [0,9223372036854775807]
3、√ The operation does not allow decimals

Per 2 the value of num1 is a decimal yet per 3 the operation is required to not allow decimals?

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: "孤傲小二～阿沐"
Дата:
Сообщение: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
Следующее
От: "孤傲小二～阿沐"
Дата:
Сообщение: 回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database