Re: [BUGS] numerics lose scale and precision in views of unions - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: [BUGS] numerics lose scale and precision in views of unions
Date
Msg-id slrnedlakr.gmd.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to Re: [BUGS] numerics lose scale and precision in views of unions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] numerics lose scale and precision in views of unions
List pgsql-hackers
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.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Win32 max connections bug (causing crashes)
Next
From: Robert Treat
Date:
Subject: Re: 8.2 features status