Firebird Internals: Inside a Firebird DatabaseDatabase Header Page — Type 0x01 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. Page Inventory Page — Type 0x02 . . . . . . . . . . . Transaction Inventory Page — Type 0x03 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 7. Pointer Page — Type 0x04 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 8. Data Page — Type 0x05 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .0 码力 | 63 页 | 261.00 KB | 1 年前3
firebird language reference 30 rusO | P | Q | R | S | T | U | V | W | X | Y | Z::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z ::= 0 | 1 | 2 | 3 | непосредственного представления данных, ниже приведён список стандартных литералов: • целочисленные — 0, -34, 45, 0X080000000; • вещественные — 0.0, -3.14, 3.23e-23; • строковые — 'текст', 'don''t!'; • дата — DATE '10 sss. DOUBLE PRECISION 64 бита 2,225 x 10-308 .. 1,797 x 10308 IEEE двойной точности, 15 цифр, размер зависит от платформы FLOAT 32 бита 1,175 x 10-38 .. 3,402 x 1038 IEEE одинарной точности, 7 цифр 0 码力 | 719 页 | 3.98 MB | 1 年前3
Firebird 2.5 LangRef Update RussianСинтаксис: 0{x|X}::= 1–16 of ::= one of 0..9, A..F, a..f Пример: SELECT 0X6FAA0D3 FROM RDB$DATABASE -- возвращает 117088467 SELECT 0X4F9 FROM RDB$DATABASE RDB$DATABASE -- возвращает 1273 SELECT 0X6E44F9A8 FROM RDB$DATABASE -- возвращает 1850014120 SELECT 0X9E44F9A8 FROM RDB$DATABASE -- возвращает 1639646808 (INTEGER) SELECT 0X09E44F9A8 FROM RDB$DATABASE -- возвращает возвращает 2655320488 ( BIGINT) SELECT 0X28ED678A4C987 FROM RDB$DATABASE -- возвращает 720001751632263 SELECT 0XFFFFFFFFFFFFFFFF FROM RDB$DATABASE -- возвращает -1 Диапазоны значений: • Шестнадцатеричные 0 码力 | 364 页 | 1.45 MB | 1 年前3
firebird 40 language reference| Q | R | S | T | U | V | W | X | Y | Z::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z ::= 0 | 1 | literals are: integer - 0, -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point - 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - -56786237632476, 0X6F55A09D42, -- 478177959234 0X7FFFFFFFFFFFFFFF, -- 9223372036854775807 0XFFFFFFFFFFFFFFFF, -- -1 0X80000000, -- -2147483648, an INTEGER 0X080000000, -- 0 码力 | 778 页 | 3.43 MB | 1 年前3
firebird 30 sprachreferenz| Q | R | S | T | U | V | W | X | Y | Z::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z Chapter 2. SQL Sprachstruktur Literalen sind: integer - 0, -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point - 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - Tageszeit. Kann nicht zum Spiechern von Zeitintervallen verwendet werden. TIMESTAMP 64 Bits (2 X 32 Bits) Von Anfang des Tages 01.01.0001 AD bis Ende des Tages 31.12.9999 AD Datum und Uhrzeit 0 码力 | 701 页 | 3.12 MB | 1 年前3
Firebird 2.1.5 Installationupdated by the installer scripts. If you leave it defined to point to the root directory of a v.1.5.x installation, there will be situations where the Firebird engine, command-line tools, cron scripts, UPDATE statement. Thus, a statement like INSERT INTO T(A, B, A) ... or UPDATE T SET A = x, B = y, A = z will be rejected in Firebird 2.n, even though it was tolerated in InterBase and Firebird service. It does not apply to Windows systems that do not have the ability to run services (Win9x, WinME). For detailed usage instructions, refer to the document README.instsvc in the doc directory0 码力 | 46 页 | 217.89 KB | 1 年前3
Firebird 2.5 Language Referencedimari GmbH (Germany) beta Eigenheim GmbH (Germany) KIMData GmbH (Germany) Jason Wharton (U.S.A) Trans-X (Sweden) Sanchez Balcewich (Uruguay) Cointec Ingenieros y Consultores, S.L. (Spain) Aage Johansen | Q | R | S | T | U | V | W | X | Y | Z::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z ::= 0 | 1 | types of literals are: integer - 0, -34, 45, 0X080000000; real - 0.0, -3.14, 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - DATE'2018-01-19'; 0 码力 | 521 页 | 2.30 MB | 1 年前3
Firebird Null Guide: NULL behaviour and pitfalls in Firebird SQLresults are in accordance with boolean logic. The fact that you don’t need to know X's value to compute “X or true” and “X and false” is also the basis of a feature found in various programming languages: ideas: Chapter 3. NULL in operations 11 • 0 times x equals 0 for every x. Hence, even if x's value is unknown, 0 * x is 0. (Note: this only holds if x’s datatype only contains numbers, not `NaN or infinities Comparisons such as “x > y” also return boolean results, but they are generally not called predicates, although this is mainly a matter of form. An expression like Greater( x, y ) that does exactly0 码力 | 69 页 | 479.63 KB | 1 年前3
firebird 5 quickstartguideFirebird-5.0.0.bbbb-p-windows-x64.exe Windows executable installer, 64 bits Firebird-5.0.0.bbbb-p-windows-x64.zip Windows zip kit for manual installation Firebird-5.0.0.bbbb-p-windows-x86.exe Windows executable executable installer, 32 bits Firebird-5.0.0.bbbb-p-linux-x64.tar.gz Linux compressed tarball Firebird-5.0.0.bbbb-p-macos-x64.pkg Mac OS-X 64-bit package ...where bbbb is the build number (e.g. 1227 for security_database.txt in your Firebird 5 installation directory, or Compatibility Issues :: Upgrading a v.2.x Security Database in the Firebird 3.0 Release Notes. Chapter 3. Installing Firebird 6 3.2.2. Installation0 码力 | 49 页 | 396.21 KB | 1 年前3
Firebird Null Guide Russianбулевой логикой. Факт состоит в том, что в порядке вы- числения «X or true» и «X and false» вам просто нет необходимости знать значение X, что так же базируется на известной особенности, которую мы знаем к следующим идеям: • 0 умноженное на x равно 0 для любого x. Поэтому, даже если значение x неизвестно, 0 * x равно 0. (Обратите внимание: это верно только если x имеет числовой тип данных, а не NaN или0 码力 | 15 页 | 288.08 KB | 1 年前3
共 27 条
- 1
- 2
- 3













