Re: [BUGS] numerics lose scale and precision in views of unions
От | mark@mark.mielke.cc |
---|---|
Тема | Re: [BUGS] numerics lose scale and precision in views of unions |
Дата | |
Msg-id | 20060810132246.GB15133@mark.mielke.cc обсуждение исходный текст |
Ответ на | Re: [BUGS] numerics lose scale and precision in views of unions (Andrew - Supernews <andrew+nonews@supernews.com>) |
Список | pgsql-hackers |
On Thu, Aug 10, 2006 at 03:40:11AM -0000, Andrew - Supernews wrote: > On 2006-08-10, Stephen Frost <sfrost@snowman.net> wrote: > >> Yeah, because numeric_cmp says that 1.0 and 1.00 are equal (what else > >> could it say? "less" and "greater" are surely wrong). So you need to > > It could say "not equal" pretty reasonably as the scale is > > different. > The comparison function must be trichotomous, that is the possible results > are "equal", "greater", and "less". There is no other "not equal" result. And it is wrong - because they are equal. But 1.0 is also equal to 1.01. We shouldn't go there. :-) Cheers, mark -- mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________ . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada One ring to rule them all, one ring to find them, one ring to bring them all and in the darkness bindthem... http://mark.mielke.cc/
В списке pgsql-hackers по дате отправления: