| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [BUGS] numerics lose scale and precision in views of unions |
| Date: | 2006-08-10 03:40:11 |
| Message-ID: | slrnedlakr.gmd.andrew+nonews@atlantis.supernews.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 2006-08-10, Stephen Frost <sfrost(at)snowman(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2006-08-10 03:44:49 | Re: [BUGS] numerics lose scale and precision in views of unions |
| Previous Message | Tom Lane | 2006-08-10 03:35:48 | Re: [BUGS] numerics lose scale and precision in views of unions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-08-10 03:40:48 | Re: Win32 max connections bug (causing crashes) |
| Previous Message | Joshua D. Drake | 2006-08-10 03:38:32 | Re: Win32 max connections bug (causing crashes) |