Menu
▾
▴
firebird-docs — chat stuff about documentation
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
(1) |
Mar
|
Apr
(36) |
May
(56) |
Jun
(1) |
Jul
(5) |
Aug
(3) |
Sep
(1) |
Oct
|
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
|
Mar
(15) |
Apr
(5) |
May
(7) |
Jun
(5) |
Jul
(3) |
Aug
(6) |
Sep
(3) |
Oct
(8) |
Nov
(23) |
Dec
(21) |
| 2003 |
Jan
(25) |
Feb
(37) |
Mar
(59) |
Apr
(11) |
May
(8) |
Jun
(24) |
Jul
(18) |
Aug
(29) |
Sep
(30) |
Oct
(11) |
Nov
(20) |
Dec
(5) |
| 2004 |
Jan
(43) |
Feb
(24) |
Mar
(61) |
Apr
(14) |
May
(23) |
Jun
(50) |
Jul
(13) |
Aug
(56) |
Sep
(55) |
Oct
(64) |
Nov
(94) |
Dec
(27) |
| 2005 |
Jan
(40) |
Feb
(10) |
Mar
(55) |
Apr
(20) |
May
(16) |
Jun
(6) |
Jul
(58) |
Aug
(38) |
Sep
(5) |
Oct
(6) |
Nov
(71) |
Dec
(99) |
| 2006 |
Jan
(6) |
Feb
(15) |
Mar
(22) |
Apr
(9) |
May
(31) |
Jun
(35) |
Jul
(47) |
Aug
(18) |
Sep
(21) |
Oct
(24) |
Nov
(63) |
Dec
(79) |
| 2007 |
Jan
(22) |
Feb
(40) |
Mar
(47) |
Apr
(69) |
May
(22) |
Jun
(20) |
Jul
(25) |
Aug
(13) |
Sep
(7) |
Oct
(44) |
Nov
(76) |
Dec
(1) |
| 2008 |
Jan
(26) |
Feb
(30) |
Mar
(120) |
Apr
(14) |
May
(22) |
Jun
(40) |
Jul
(48) |
Aug
(7) |
Sep
(34) |
Oct
(31) |
Nov
|
Dec
(30) |
| 2009 |
Jan
(9) |
Feb
(6) |
Mar
(9) |
Apr
(2) |
May
(9) |
Jun
|
Jul
(31) |
Aug
(32) |
Sep
(15) |
Oct
(23) |
Nov
|
Dec
(9) |
| 2010 |
Jan
(19) |
Feb
(9) |
Mar
|
Apr
|
May
(9) |
Jun
(6) |
Jul
(8) |
Aug
(21) |
Sep
(10) |
Oct
(1) |
Nov
(3) |
Dec
(33) |
| 2011 |
Jan
|
Feb
(1) |
Mar
(4) |
Apr
(10) |
May
|
Jun
(9) |
Jul
(23) |
Aug
(2) |
Sep
(35) |
Oct
(36) |
Nov
|
Dec
(4) |
| 2012 |
Jan
(3) |
Feb
(8) |
Mar
(3) |
Apr
|
May
|
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
(12) |
Nov
(12) |
Dec
|
| 2013 |
Jan
(18) |
Feb
(5) |
Mar
(1) |
Apr
|
May
|
Jun
(5) |
Jul
|
Aug
(21) |
Sep
|
Oct
(5) |
Nov
(1) |
Dec
(11) |
| 2014 |
Jan
|
Feb
|
Mar
(4) |
Apr
(2) |
May
|
Jun
|
Jul
(2) |
Aug
(5) |
Sep
(6) |
Oct
|
Nov
(29) |
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
(14) |
Apr
|
May
|
Jun
|
Jul
(7) |
Aug
(7) |
Sep
(5) |
Oct
|
Nov
(6) |
Dec
(3) |
| 2016 |
Jan
(14) |
Feb
(9) |
Mar
(33) |
Apr
(12) |
May
(18) |
Jun
(3) |
Jul
|
Aug
(15) |
Sep
|
Oct
|
Nov
|
Dec
(22) |
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(10) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(44) |
Nov
(32) |
Dec
(8) |
| 2018 |
Jan
(2) |
Feb
(25) |
Mar
(16) |
Apr
(11) |
May
(1) |
Jun
(19) |
Jul
(3) |
Aug
|
Sep
|
Oct
(25) |
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
(2) |
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
(3) |
| 2020 |
Jan
(29) |
Feb
(28) |
Mar
(13) |
Apr
(13) |
May
(107) |
Jun
(75) |
Jul
(57) |
Aug
(36) |
Sep
(3) |
Oct
(4) |
Nov
(4) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(13) |
Mar
(5) |
Apr
(6) |
May
(44) |
Jun
(9) |
Jul
(9) |
Aug
(3) |
Sep
(11) |
Oct
(5) |
Nov
(14) |
Dec
(19) |
| 2022 |
Jan
(1) |
Feb
|
Mar
|
Apr
(4) |
May
(1) |
Jun
(1) |
Jul
(13) |
Aug
(6) |
Sep
(2) |
Oct
(7) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
|
Mar
(13) |
Apr
(2) |
May
(31) |
Jun
(12) |
Jul
(5) |
Aug
(5) |
Sep
(27) |
Oct
(7) |
Nov
(25) |
Dec
(7) |
| 2024 |
Jan
(11) |
Feb
(27) |
Mar
(3) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Stefan H. <st...@de...> - 2016-08-11 13:24:33
|
Martin, > How would you translate COLLATION or COLLATE? Do we translate this > or leave it as it is? In this case I'd suggest to stay with "Collation". A collation is different from a "sort order" (Sortierreihenfolge). It's more like the algorithm that "does" the sorting. (Sort order is more the result of what the collation has done.) Collations are also not only used for sorting (order by) but also for comparisons (A=B). "Sortiermethode" would probably fit better, but I would just use the English term Collation also in the German translations. It would also make it easier to read English language documentation after one has read the German one. Regards Stefan |
|
From: Paul V. <pa...@vi...> - 2016-08-11 10:40:07
|
Hi all, >> Floating point data types are stored in an IEEE 754 binary format that >> comprises sign, exponent and mantissa. Precision is dynamic, >> corresponding to the physical storage format of the value, which may >> be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE >> PRECISION. > > It's exactly either 4 or 8 bytes, not "up to". The storage used is 4 or 8 bytes, but the precision is less, because a number of bits are used for sign and exponent. FLOAT precision is 24 bits - roughly 7 decimal digits. The binary exponent's range is -126..127, which - again, roughly - corresponds to -38..38 base 10. DOUBLE precision is 53 bits (around 16 decimal digits) and the exponent ranges from -1022 to 1023 binary or roughly -308 to 308 decimal. The precision is not dynamic (except when precision is lost because the number is too small to be normalized, but I think that's outside the scope of an SQL reference). Cheers, Paul |
|
From: Helen B. <he...@us...> - 2016-08-11 09:41:39
|
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv16889 Modified Files: fblangref25-datatypes.xml fblangref25.xml Log Message: Corrected text for floating-point data types (Build 0.906) Index: fblangref25-datatypes.xml =================================================================== RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-datatypes.xml,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- fblangref25-datatypes.xml 27 Mar 2016 21:20:47 -0000 1.6 +++ fblangref25-datatypes.xml 11 Aug 2016 08:52:46 -0000 1.7 @@ -262,9 +262,9 @@ <section id="fblangref25-datatypes-floattypes"> <title><database>Floating-Point Data Types</database></title> - <para>Floating-point data types are examples of data stored in the DBMS with the precision matching the - scale of the number. <database>FLOAT</database> and <database>DOUBLE PRECISION</database> (DOUBLE) - are examples.</para> + <para>Floating point data types are stored in an IEEE 754 binary format that comprises sign, + exponent and mantissa. Precision is dynamic, corresponding to the physical storage format of + the value, which is exactly 4 bytes for the FLOAT type and 8 bytes for DOUBLE PRECISION.</para> <para>Considering the peculiarities of storing floating-point numbers in a database, these data types are not recommended for storing monetary data. For the same reasons, columns with floating-point data are not recommended for use as keys or to have uniqueness constraints applied to them.</para> Index: fblangref25.xml =================================================================== RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25.xml,v retrieving revision 1.22 retrieving revision 1.23 diff -u -d -r1.22 -r1.23 --- fblangref25.xml 13 May 2016 10:14:26 -0000 1.22 +++ fblangref25.xml 11 Aug 2016 08:52:46 -0000 1.23 @@ -5,7 +5,7 @@ <bookinfo> <title>Firebird 2.5 Language Reference</title> <subtitle>Beta Release 1</subtitle> - <edition>12 May 2016, document version 0.905</edition> + <edition>11 August 2016, document version 0.906</edition> <authorgroup> <author> <firstname>Dmitry</firstname> ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Firebird-checkins mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-checkins |
|
From: Mark R. <ma...@la...> - 2016-08-11 08:06:14
|
On 2016-08-10 10:31, Köditz wrote:
> Hi,
>
> just a question for German-speaking people. How would you translate
> COLLATION or COLLATE? Do we translate this or leave it as it is?
> Currently I use the German term "Sortierreihenfolge" but I don't know
> if this is OK and understandable. So what is your opinion on this?
>
> Regards,
>
> Martin
Interglot[1] suggests:
collation:
Vergleich
; Gleichung
; Gleichnis
; Sortierung
collate:
gleichstellen
Wiktionary:
collation → Kollation
collate → zuordnen
, kollationieren
, mischen
, vergleichen
, abgleichen
collate → stimmen
, einstellen
, berichtigen
, führen
, leiten
, lenken
Also take into consideration whether you should translate this term. I
know it is different in German, but in Dutch it is very usual (at least
in the last 10-15 years) to use specific technology terminology
untranslated.
[1]: http://www.interglot.com/dictionary/en/de/search?q=collation&m=
Mark
|
|
From: Köditz, M. <Mar...@it...> - 2016-08-11 07:51:30
|
Hi Helen, yes i did. Martin -----Ursprüngliche Nachricht----- Von: Helen Borrie [mailto:he...@ii...] Gesendet: Donnerstag, 11. August 2016 09:26 An: Chatter regarding Firebird documentation Betreff: Re: [Firebird-docs] Scale of number and precision on floating data types Hello Martin, Thursday, August 11, 2016, 6:00:52 PM, you wrote: > The wording is OK. I will use it. Did you catch Dmitry's correction? > -----Ursprüngliche Nachricht----- > Von: Dmitry Yemanov [mailto:fir...@ya...] > Gesendet: Donnerstag, 11. August 2016 07:19 > An: Chatter regarding Firebird documentation > Betreff: Re: [Firebird-docs] Scale of number and precision on floating > data types > 11.08.2016 06:38, Helen Borrie wrote: >> >> Floating point data types are stored in an IEEE 754 binary format >> that comprises sign, exponent and mantissa. Precision is dynamic, >> corresponding to the physical storage format of the value, which may >> be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE >> PRECISION. > It's exactly either 4 or 8 bytes, not "up to". > Dmitry > ---------------------------------------------------------------------- > -------- What NetFlow Analyzer can do for you? Monitors network > bandwidth and traffic patterns at an interface-level. Reveals which > users, apps, and protocols are consuming the most bandwidth. Provides > multi-vendor support for NetFlow, J-Flow, sFlow and other flows. > Make informed decisions using capacity planning reports. > http://sdm.link/zohodev2dev > _______________________________________________ > Firebird-docs mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-docs > ---------------------------------------------------------------------- > -------- What NetFlow Analyzer can do for you? Monitors network > bandwidth and traffic patterns at an interface-level. Reveals which > users, apps, and protocols are consuming the most bandwidth. Provides > multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make > informed decisions using capacity planning reports. > http://sdm.link/zohodev2dev > _______________________________________________ > Firebird-docs mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-docs -- Kind regards, Helen Borrie ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Firebird-docs mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-docs |
|
From: Helen B. <he...@ii...> - 2016-08-11 07:26:29
|
Hello Martin, Thursday, August 11, 2016, 6:00:52 PM, you wrote: > The wording is OK. I will use it. Did you catch Dmitry's correction? > -----Ursprüngliche Nachricht----- > Von: Dmitry Yemanov [mailto:fir...@ya...] > Gesendet: Donnerstag, 11. August 2016 07:19 > An: Chatter regarding Firebird documentation > Betreff: Re: [Firebird-docs] Scale of number and precision on floating data types > 11.08.2016 06:38, Helen Borrie wrote: >> >> Floating point data types are stored in an IEEE 754 binary format that >> comprises sign, exponent and mantissa. Precision is dynamic, >> corresponding to the physical storage format of the value, which may >> be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE >> PRECISION. > It's exactly either 4 or 8 bytes, not "up to". > Dmitry > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth > and traffic patterns at an interface-level. Reveals which users, > apps, and protocols are consuming the most bandwidth. Provides > multi-vendor support for NetFlow, J-Flow, sFlow and other flows. > Make informed decisions using capacity planning reports. > http://sdm.link/zohodev2dev > _______________________________________________ > Firebird-docs mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-docs > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. http://sdm.link/zohodev2dev > _______________________________________________ > Firebird-docs mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-docs -- Kind regards, Helen Borrie |
|
From: Köditz, M. <Mar...@it...> - 2016-08-11 06:01:02
|
The wording is OK. I will use it. Martin -----Ursprüngliche Nachricht----- Von: Dmitry Yemanov [mailto:fir...@ya...] Gesendet: Donnerstag, 11. August 2016 07:19 An: Chatter regarding Firebird documentation Betreff: Re: [Firebird-docs] Scale of number and precision on floating data types 11.08.2016 06:38, Helen Borrie wrote: > > Floating point data types are stored in an IEEE 754 binary format that > comprises sign, exponent and mantissa. Precision is dynamic, > corresponding to the physical storage format of the value, which may > be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE > PRECISION. It's exactly either 4 or 8 bytes, not "up to". Dmitry ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Firebird-docs mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-docs |
|
From: Dmitry Y. <fir...@ya...> - 2016-08-11 05:18:46
|
11.08.2016 06:38, Helen Borrie wrote: > > Floating point data types are stored in an IEEE 754 binary format that > comprises sign, exponent and mantissa. Precision is dynamic, > corresponding to the physical storage format of the value, which may > be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE > PRECISION. It's exactly either 4 or 8 bytes, not "up to". Dmitry |
|
From: Helen B. <he...@ii...> - 2016-08-11 03:38:40
|
Hello Dmitry,
Thursday, August 11, 2016, 9:42:48 AM, you wrote:
> Nope, floating point numbers are stored completely different to the
> fixed point numbers. FLOAT is single-precision format which occupies 4
> bytes. DOUBLE is double-precision format which occupies 8 bytes. But
> they have no relationship to INT/BIGINT despite the byte size (4/8
> bytes), the binary layout is different (see IEEE 754) and it embeds
> {sign, exponent, mantissa}.
> I suppose the intended meaning was something like: floating point data
> types represent data stored in the database with the dynamic precision
> corresponding its storage format (physical size of the value).
OK...how about this wording to substitute for the troublesome
translation:
"
Floating point data types are stored in an IEEE 754 binary format that
comprises sign, exponent and mantissa. Precision is dynamic,
corresponding to the physical storage format of the value, which may
be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE
PRECISION.
"
I would be loath to mention "scale" at all as it is not relevant for
floating-point types.
Comments? Enhancements? Martin, if that wording between the quotes
is a correct interpretation, would it work for your translation?
Helen
|
|
From: Dmitry Y. <fir...@ya...> - 2016-08-10 21:42:57
|
10.08.2016 23:35, Helen Borrie wrote:
>
>> I hang on a text part in fblangref25-datatypes.xml -> fblangref25-datatypes-floattypes:
>> Floating-point data types are examples of data stored in the DBMS with the precision matching the scale of the number.
>
>> What is the scale of number? Please make this clear. Otherwise I don’t get the correct translation.
>
> I don't like this at all. I think it needs some input from Paul and
> Dmitry and we should rewrite it.
I agree the wording is incorrect. The Russian original is slightly
better but still far from being a good one.
> The way I understand the storage of floating point numbers:
>
> FLOAT is stored as INTEGER (precision 9, scale 0) with the scale
> (stored separately) depending on the position of the decimal point.
>
> DOUBLE PRECISION is stored as BIGINT (18,0) with scale
> depending on the position of the decimal point.
Nope, floating point numbers are stored completely different to the
fixed point numbers. FLOAT is single-precision format which occupies 4
bytes. DOUBLE is double-precision format which occupies 8 bytes. But
they have no relationship to INT/BIGINT despite the byte size (4/8
bytes), the binary layout is different (see IEEE 754) and it embeds
{sign, exponent, mantissa}.
I suppose the intended meaning was something like: floating point data
types represent data stored in the database with the dynamic precision
corresponding its storage format (physical size of the value).
Dmitry
|
|
From: M. R. <ma...@la...> - 2016-08-10 21:24:52
|
No, that is not how floating point works. The storage is different from integers or bigint, as it is, the text makes no sense at all. Mark ----- Bericht beantwoorden ----- Van: "Helen Borrie" <he...@ii...> Aan: "Chatter regarding Firebird documentation" <fir...@li...> Onderwerp: [Firebird-docs] Scale of number and precision on floating data types Datum: wo, aug. 10, 2016 22:35 Hello , Wednesday, August 10, 2016, 9:20:50 PM, Martin Koeditz wrote: > I hang on a text part in fblangref25-datatypes.xml -> fblangref25-datatypes-floattypes: > Floating-point data types are examples of data stored in the DBMS with the precision matching the scale of the number. > What is the scale of number? Please make this clear. Otherwise I don’t get the correct translation. I don't like this at all. I think it needs some input from Paul and Dmitry and we should rewrite it. The way I understand the storage of floating point numbers: FLOAT is stored as INTEGER (precision 9, scale 0) with the scale (stored separately) depending on the position of the decimal point. DOUBLE PRECISION is stored as BIGINT (18,0) with scale depending on the position of the decimal point. So (as I understand), floating point and fixed point numbers are stored in the same manner. The difference - understood by the engine - is that the *accuracy* of floating point numbers is reduced as the scale increases. The *accuracy* of the last two digits is always unreliable; hence, the more the decimal point moves to the right, the less accurate the number. This assumption does need confirmation or correction, though. The correctness of the statement aside, is your question about how to translate the words "precision" and "scale"? Possibly Thomas can help with that, as he did the German translations of quite a few of the earlier documents and often writes articles for German publications. Helen ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Firebird-docs mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-docs |
|
From: Helen B. <he...@ii...> - 2016-08-10 20:36:11
|
Hello , Wednesday, August 10, 2016, 9:20:50 PM, Martin Koeditz wrote: > I hang on a text part in fblangref25-datatypes.xml -> fblangref25-datatypes-floattypes: > Floating-point data types are examples of data stored in the DBMS with the precision matching the scale of the number. > What is the scale of number? Please make this clear. Otherwise I don’t get the correct translation. I don't like this at all. I think it needs some input from Paul and Dmitry and we should rewrite it. The way I understand the storage of floating point numbers: FLOAT is stored as INTEGER (precision 9, scale 0) with the scale (stored separately) depending on the position of the decimal point. DOUBLE PRECISION is stored as BIGINT (18,0) with scale depending on the position of the decimal point. So (as I understand), floating point and fixed point numbers are stored in the same manner. The difference - understood by the engine - is that the *accuracy* of floating point numbers is reduced as the scale increases. The *accuracy* of the last two digits is always unreliable; hence, the more the decimal point moves to the right, the less accurate the number. This assumption does need confirmation or correction, though. The correctness of the statement aside, is your question about how to translate the words "precision" and "scale"? Possibly Thomas can help with that, as he did the German translations of quite a few of the earlier documents and often writes articles for German publications. Helen |
|
From: Köditz, M. <Mar...@it...> - 2016-08-10 09:33:37
|
Hi all, I hang on a text part in fblangref25-datatypes.xml -> fblangref25-datatypes-floattypes: Floating-point data types are examples of data stored in the DBMS with the precision matching the scale of the number. What is the scale of number? Please make this clear. Otherwise I don't get the correct translation. Regards Martin |
|
From: Köditz, M. <Mar...@it...> - 2016-08-10 09:33:36
|
Hi, just a question for German-speaking people. How would you translate COLLATION or COLLATE? Do we translate this or leave it as it is? Currently I use the German term "Sortierreihenfolge" but I don't know if this is OK and understandable. So what is your opinion on this? Regards, Martin |
|
From: Helen B. <he...@ii...> - 2016-08-06 21:01:12
|
Martin, your mail server is rejecting all my attempts to send you an email, from this address and 5 others! The rejection message in all cases is 5.3.0 - Other mail system problem 550-'5.7.1 Message rejected as spam by Content Filtering.' Is there some way you can whitelist at least this one? (he...@ii...) Thanks! Helen |
|
From: Paul V. <pa...@vi...> - 2016-06-13 01:10:19
|
Hi all, >> There is broken link >> (http://developer.postgresql.org/cvsweb.cgi/#dirlist) at the page >> http://firebirdsql.com/manual/docwritehowto-copyrights.html, using this >> text "http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/" >> >> I assume that associated document should be regenerated and republished >> to remove this link? > > Yes. The HTML could also be edited directly on-site, but the PDF must be rebuilt. > > I'll update the sources and rebuild HTML + PDF this week. OK, done. Cheers, Paul Vinkenoog |
|
From: Paul V. <pa...@vi...> - 2016-06-08 12:22:58
|
Hi Alexey, > There is broken link > (http://developer.postgresql.org/cvsweb.cgi/#dirlist) at the page > http://firebirdsql.com/manual/docwritehowto-copyrights.html, using this > text "http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/" > > I assume that associated document should be regenerated and republished > to remove this link? Yes. The HTML could also be edited directly on-site, but the PDF must be rebuilt. I'll update the sources and rebuild HTML + PDF this week. Cheers, Paul |
|
From: Alexey K. <ak...@ib...> - 2016-06-08 11:41:35
|
Hi, There is broken link (http://developer.postgresql.org/cvsweb.cgi/#dirlist) at the page http://firebirdsql.com/manual/docwritehowto-copyrights.html, using this text "http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/" I assume that associated document should be regenerated and republished to remove this link? Regards, Alexey |
|
From: Jiří Č. <ji...@ci...> - 2016-05-20 08:53:42
|
> No, this is impossible. Although in theory it could work, by passing the > specified architecture to the engine via isc_dpb_config thus overriding > the value in firebird.conf. What a pity. Starting different editions for testing the provider is going to be a lot of fiddling with configuration file. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Dmitry Y. <fir...@ya...> - 2016-05-20 07:19:48
|
20.05.2016 10:12, Jiří Činčura wrote: > I was looking for a hint whether I can select CS/SC/SS from command > line, instead of modifying firebird.conf. No, this is impossible. Although in theory it could work, by passing the specified architecture to the engine via isc_dpb_config thus overriding the value in firebird.conf. Dmitry |
|
From: Jiří Č. <ji...@ci...> - 2016-05-20 07:12:21
|
> I doubt there's any. Do you need to know something particular? I was looking for a hint whether I can select CS/SC/SS from command line, instead of modifying firebird.conf. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Dmitry Y. <fir...@ya...> - 2016-05-20 06:48:39
|
20.05.2016 09:40, Jiří Činčura wrote: > > is there some document with switches for firebird.exe? All I see is > gbak, gfix, ... RN seem to not have such section either. I doubt there's any. Do you need to know something particular? Dmitry |
|
From: Jiří Č. <ji...@ci...> - 2016-05-20 06:40:33
|
Hi *, is there some document with switches for firebird.exe? All I see is gbak, gfix, ... RN seem to not have such section either. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Helen B. <he...@ii...> - 2016-05-13 19:34:47
|
To translators: I just redirected the CVS notification regarding the latest batch of corrections in fblangref25-commons.xml and fblangref25-functions-vars.xml. In both cases, these are files that are marked as already reviewed. New builds (doc version 0.905) of both PDF and HTML are on the web site. The HTML was built using the new version of the stylesheet with the sub-TOCs. Cheers, Helen |
|
From: Helen B. <he...@us...> - 2016-05-13 19:27:57
|
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv23534 Modified Files: fblangref25-commons.xml fblangref25-functions-vars.xml fblangref25.xml Log Message: Corrections from P. Vinkenoog and D. Simonov. Index: fblangref25-functions-vars.xml =================================================================== RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-functions-vars.xml,v retrieving revision 1.5 retrieving revision 1.6 diff -u -d -r1.5 -r1.6 --- fblangref25-functions-vars.xml 27 Mar 2016 21:20:48 -0000 1.5 +++ fblangref25-functions-vars.xml 13 May 2016 10:14:26 -0000 1.6 @@ -5085,7 +5085,7 @@ <formalpara> <title>Syntax</title> <para><blockquote> - <programlisting>BIN_AND (<replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> + <programlisting>BIN_AND (<replaceable>number</replaceable>, <replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> </blockquote></para> </formalpara> <table id="fblangref25-funcs-tbl-binand"> @@ -5103,15 +5103,19 @@ <tbody> <row valign="middle"> <entry align="center">number</entry> - <entry align="left">A 32-bit or 64-bit integer</entry> + <entry align="left">Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)</entry> </row> </tbody> </tgroup> </table> <formalpara> <title>Result type</title> - <para><database>INTEGER</database> or <database>BIGINT</database></para> + <para><database>SMALLINT</database>, <database>INTEGER</database> or <database>BIGINT</database></para> </formalpara> + <note> + <para>SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) + with n <= 4; otherwise small integers return an INTEGER result.</para> + </note> <formalpara> <title>Description</title> <para>Returns the result of the bitwise AND operation on the argument(s).</para> @@ -5133,8 +5137,7 @@ </formalpara> <formalpara> <title>Possible name conflict</title> - <para> YES—<link linkend="fblangref25-functions-nameclashes">>Read details</link> - </para> + <para> NO</para> </formalpara> <formalpara> @@ -5159,19 +5162,23 @@ <tbody> <row valign="middle"> <entry align="center">number</entry> - <entry align="left">A 32-bit or 64-bit integer</entry> + <entry align="left">Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)</entry> </row> </tbody> </tgroup> </table> <formalpara> <title>Result type</title> - <para><database>INTEGER</database> or <database>BIGINT</database></para> + <para><database>SMALLINT</database>, <database>INTEGER</database> or <database>BIGINT</database></para> </formalpara> + <note> + <para>SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) + with n <= 4; otherwise small integers return an INTEGER result.</para> + </note> <formalpara> <title>Description</title> - <para>Returns the result of the bitwise NOT operation on the argument, i.e., negation, - or <firstterm>ones complement</firstterm>.</para> + <para>Returns the result of the bitwise NOT operation on the argument, i.e., + <firstterm>ones complement</firstterm>.</para> </formalpara> <formalpara> <title>See also</title> @@ -5196,7 +5203,7 @@ <formalpara> <title>Syntax</title> <para><blockquote> - <programlisting>BIN_OR (<replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> + <programlisting>BIN_OR (<replaceable>number</replaceable>, <replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> </blockquote></para> </formalpara> <table id="fblangref25-funcs-tbl-binor"> @@ -5214,15 +5221,19 @@ <tbody> <row valign="middle"> <entry align="center">number</entry> - <entry align="left">A number of an integer type</entry> + <entry align="left">Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)</entry> </row> </tbody> </tgroup> </table> <formalpara> <title>Result type</title> - <para><database>INTEGER</database> or <database>BIGINT</database></para> + <para><database>SMALLINT</database>, <database>INTEGER</database> or <database>BIGINT</database></para> </formalpara> + <note> + <para>SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) + with n <= 4; otherwise small integers return an INTEGER result.</para> + </note> <formalpara> <title>Description</title> <para>Returns the result of the bitwise OR operation on the argument(s).</para> @@ -5365,7 +5376,7 @@ <formalpara> <title>Syntax</title> <para><blockquote> - <programlisting>BIN_XOR (<replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> + <programlisting>BIN_XOR (<replaceable>number</replaceable>, <replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting> </blockquote></para> </formalpara> <table id="fblangref25-funcs-tbl-binxor"> @@ -5383,7 +5394,7 @@ <tbody> <row valign="middle"> <entry align="center">number</entry> - <entry align="left">A number of an integer type</entry> + <entry align="left">Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)</entry> </row> </tbody> </tgroup> @@ -5394,8 +5405,12 @@ </formalpara> <formalpara> <title>Result type</title> - <para><database>INTEGER</database> or <database>BIGINT</database></para> + <para><database>SMALLINT</database>, <database>INTEGER</database> or <database>BIGINT</database></para> </formalpara> + <note> + <para>SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) + with n <= 4; otherwise small integers return an INTEGER result.</para> + </note> <formalpara> <title>See also</title> <para> <link linkend="fblangref25-functions-scalarfuncs-bin_and"><database>BIN_AND</database></link>, Index: fblangref25-commons.xml =================================================================== RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- fblangref25-commons.xml 26 Apr 2016 22:38:33 -0000 1.8 +++ fblangref25-commons.xml 13 May 2016 10:14:26 -0000 1.9 @@ -396,24 +396,34 @@ </thead> <tbody> <row valign="middle"> + <entry align="center"><command>+ <replaceable>signed_number</replaceable></command></entry> + <entry align="center">Unary plus</entry> + <entry align="center">1</entry> + </row> + <row valign="middle"> + <entry align="center"><command>- <replaceable>signed_number</replaceable></command></entry> + <entry align="center">Unary minus</entry> + <entry align="center">1</entry> + </row> + <row valign="middle"> <entry align="center"><command>*</command></entry> <entry align="center">Multiplication</entry> - <entry align="center">1</entry> + <entry align="center">2</entry> </row> <row valign="middle"> <entry align="center"><command>/</command></entry> <entry align="center">Division</entry> - <entry align="center">1</entry> + <entry align="center">2</entry> </row> <row valign="middle"> <entry align="center"><command>+</command></entry> <entry align="center">Addition</entry> - <entry align="center">2</entry> + <entry align="center">3</entry> </row> <row valign="middle"> <entry align="center"><command>-</command></entry> <entry align="center">Subtraction</entry> - <entry align="center">2</entry> + <entry align="center">3</entry> </row> </tbody> </tgroup> @@ -426,9 +436,9 @@ </programlisting> </formalpara> <note> - <para>Where operators have the same precedence, they are evaluated in + <para>Where operators have the same precedence, they are evaluated in left-to-right sequence.</para> - </note> + </note> </section><!-- Arithmetic operators --> <section id="fblangref25-commons-compar"> @@ -456,43 +466,43 @@ <row valign="middle"> <entry align="center"><command><>, !=, ~=, ^=</command></entry> <entry align="center">Is not equal to</entry> - <entry align="center">2</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command>></command></entry> <entry align="center">Is greater than</entry> - <entry align="center">3</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command><</command></entry> <entry align="center">Is less than</entry> - <entry align="center">4</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command>>=</command></entry> <entry align="center">Is greater than or equal to</entry> - <entry align="center">5</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command><=</command></entry> <entry align="center">Is less than or equal to</entry> - <entry align="center">6</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command>!>, ~>, ^></command></entry> <entry align="center">Is not greater than</entry> - <entry align="center">7</entry> + <entry align="center">1</entry> </row> <row valign="middle"> <entry align="center"><command>!<, ~<, ^<</command></entry> <entry align="center">Is not less than</entry> - <entry align="center">8</entry> + <entry align="center">1</entry> </row> </tbody> </tgroup> </table> <para>This group also includes comparison predicates <database>BETWEEN, LIKE, - CONTAINING, SIMILAR TO</database> and others.</para> + CONTAINING, SIMILAR TO, IS</database> and others.</para> <formalpara><title>Example</title> <programlisting> IF (SALARY > 1400) THEN @@ -991,8 +1001,8 @@ </programlisting> </formalpara> <para>The <database>LIKE</database> predicate compares the character-type expression with - the pattern defined in the second expression. Case- or accent-sensitivity for the comparison - is determined by the collation that is in use. A collation can be specified for either + the pattern defined in the second expression. Case- or accent-sensitivity for the comparison + is determined by the collation that is in use. A collation can be specified for either operand, if required.</para> <section id="fblangref25-commons-wildcards"> @@ -1011,8 +1021,8 @@ <section id="fblangref25-commons-escapechar"> <title>Using the <database>ESCAPE</database> Character Option</title> - <para>If the search string contains either of the wildcard symbols, the <database>ESCAPE</database> - clause can be used to specify an escape character. The escape character must precede the '%' or '_' + <para>If the search string contains either of the wildcard symbols, the <database>ESCAPE</database> + clause can be used to specify an escape character. The escape character must precede the '%' or '_' symbol in the search string, to indicate that the symbol is to be interpreted as a literal character.</para> </section> @@ -1055,9 +1065,9 @@ WHERE ADDRESS LIKE '%Rostov%' </programlisting> <note> - <para>If you need to do a case-insensitive search for something <emphasis>enclosed - inside</emphasis> a string (<function> LIKE '%Abc%' </function>), use of - the <database>CONTAINING</database> predicate is recommended, in preference to + <para>If you need to do a case-insensitive search for something <emphasis>enclosed + inside</emphasis> a string (<function> LIKE '%Abc%' </function>), use of + the <database>CONTAINING</database> predicate is recommended, in preference to the <database>LIKE</database> predicate.</para> </note> </listitem> @@ -1123,7 +1133,7 @@ <para>The <database>CONTAINING</database> predicate searches for a string or a string-like type looking for the sequence of characters that matches its argument. It can be used for an alphanumeric (string-like) search on numbers and dates. A <database>CONTAINING</database> - search is not case-sensitive. However, if an accent-sensitive collation is in use then + search is not case-sensitive. However, if an accent-sensitive collation is in use then the search will be accent-sensitive.</para> <para>When <database>CONTAINING</database> is used in the search conditions of DML queries, the Firebird optimizer can use an index on the searched column, if a suitable one exists.</para> @@ -1338,7 +1348,7 @@ 'Framboise' similar to 'Fr[^a][^a]boise' -- false 'Framboise' similar to 'Fra[^[:DIGIT:]]boise' -- true </programlisting> - If the caret is not placed at the start of the sequence, the class contains everything + If the caret is not placed at the start of the sequence, the class contains everything before the caret, except for the elements that also occur after the caret: <programlisting> 'Grapefruit' similar to 'Grap[a-m^f-i]fruit' -- true @@ -1498,6 +1508,12 @@ </para> </formalpara> </section> <!-- is not null --> + <note> + <title>Note regarding the IS predicates</title> + <para>Up to and including Firebird 2.5, the <database>IS</database> predicates, like + the other comparison predicates, do not have precedence over the others. In Firebird 3.0 + and higher, these predicates take precedence above the others.</para> + </note> </section><!-- Other comparison predicates --> </section><!-- Comparison predicates --> Index: fblangref25.xml =================================================================== RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25.xml,v retrieving revision 1.21 retrieving revision 1.22 diff -u -d -r1.21 -r1.22 --- fblangref25.xml 26 Apr 2016 22:38:33 -0000 1.21 +++ fblangref25.xml 13 May 2016 10:14:26 -0000 1.22 @@ -5,7 +5,7 @@ <bookinfo> <title>Firebird 2.5 Language Reference</title> <subtitle>Beta Release 1</subtitle> - <edition>26 April 2016, document version 0.904</edition> + <edition>12 May 2016, document version 0.905</edition> <authorgroup> <author> <firstname>Dmitry</firstname> ------------------------------------------------------------------------------ Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j _______________________________________________ Firebird-checkins mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-checkins |
58 messages has been excluded from this view by a project administrator.
