Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Strage difference between precision in literals
Date: Tue, 26 Apr 2022 20:26:49 +0200
Organization: Erland Sommarskog
Lines: 7
Message-ID: <XnsAE85CFFF8BA43Yazorman@127.0.0.1>
References: <20220423190412.a205fc87d4859bba4556212f@gmail.com> <XnsAE84DF8AE8C27Yazorman@127.0.0.1> <20220426132146.ac3b20b81af37ef0943603c6@g{oogle}mail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="19e09ff6995d5893716de3dc2042b1c4"; logging-data="23184"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19maE1OYqCpkXgIknuNQW0h"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:YGR6cSAHWMcTxEwwnExLmipDrcU=
Xref: csiph.com comp.databases.ms-sqlserver:2123

Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> I think your outer `CAST' is superfluous because it can-
> not increase actual precision.
> 

Yeah, but from a distance I couldn't tell whether you want a decimal
or a float result, so I added the cast.