proposal: numeric scale functions

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема proposal: numeric scale functions
Дата
Msg-id 5643125E.1030605@joh.to
обсуждение исходный текст
Ответы Re: proposal: numeric scale functions
Список pgsql-hackers
Hi,

Dealing with "numeric"s right now in cases where it's really important 
that the scale is correct is quite painful.  For example, if I want to 
accept a EUR amount as an input, I often want to reject values such as 
'21.413', but I'd be fine with e.g. '21.410000'.  My suggestion is to 
add two functions: one to return the number of decimal places in a 
numeric, and another one to remove non-significant decimal places. 
These two functions are useful on their own, and when combined allow you 
to look at the number of significant decimal places in a numeric.

Any thoughts, objections?


.m



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Proposal: "Causal reads" mode for load balancing reads without stale data
Следующее
От: Ants Aasma
Дата:
Сообщение: Re: Proposal: "Causal reads" mode for load balancing reads without stale data