Excellent explanation Mark! Thanks
*Salim NAUFAL*
*General Manager*
Twin Towers, 21 Camille Chamoun Street
Horch Tabet, Metn, 2707 6209, Lebanon
*Tel/Fax.* +961 (0)1 499578
*Mobile. * +961 (0)3 689569
*Email.* s.nau...@softnet.me
[Non-text portions of this message have been removed]
On 2018-01-26 19:51, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
>> I am not familiar with the details of the SQL standard, is this the
>> proper was to round and calculate numeric values in SQL?
>
> You really do need to familiarise yourself with the way SQL handles
> numbers,
On 2018-01-26 16:17, Salim Naufal s.nau...@softnet.me [firebird-support]
wrote:
> I have noticed the following inconsistencies in Firebird 3.02:
>
> Try performing the following calculations:
>
> SELECT (1 - (1/1.11)) FROM RDB$DATABASEresult is rounded and
> yields 0.10 (rounded result)
Thanks Helen and Dimitry. This definitely is useful to know. I thought that
it would work like programming languages where, for example, combining an
integer with a floating point would result into a floating point number.
Thanks again
On Fri, Jan 26, 2018 at 8:52 PM Helen Borrie
Salim Naufal wrote:
> I have noticed the following inconsistencies in Firebird 3.02:
[..]
> I then tried:
> SELECT CAST(1 AS NUMERIC(18,2)) * (1.00 - (1.00/1.11)) FROM
> RDB$DATABASE and got a much better result of 991.0
> Finally, the correct result is retrieved using:
> SELECT
26.01.2018 16:17, Salim Naufal s.nau...@softnet.me [firebird-support] wrote:
> I am not familiar with the details of the SQL standard, is this the proper
> was to round
> and calculate numeric values in SQL?
Yes. In your first examples you don't use floating point numbers, but exact
I have noticed the following inconsistencies in Firebird 3.02:
Try performing the following calculations:
*select (1 - (1/1.11)) FROM RDB$DATABASE*result is rounded and yields
0.10 (rounded result)
to rule out any results being incorrectly displayed, I tried:
*SELECT 1 * (select (1 -
26.01.2018 13:37, daniel.acherm...@logismos.com [firebird-support] wrote:
> One of our customer is interested in the Firebird 3 feature of a "over the
> wire"
> connection encryption. This customer however prefers the AES-protocol instead
> of the
> default plug in with arc4.
AES can
<>
As far as I am aware the only current commercially available plugins for
Firebird are for encryption.
If your customer is interested in such a plugin, we could probably develop one
for them.
Regards
Paul
Dear all!
One of our customer is interested in the Firebird 3 feature of a "over the
wire" connection encryption. This customer however prefers the AES-protocol
instead of the default plug in with arc4.
I searched over the internet but I could not find any AES plugin (I could
finally it only
10 matches
Mail list logo
