cache is an area of RAM allocated to store (cache) database pages in memory to help improve the efficiency of the database performance. It is far quicker to read data from memory that it is to have to

one-dimensional and multi-dimensional and of any data type except BLOB and ARRAY. Example CREATE TABLE SAMPLE_ARR ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [4] ); This example will create a table two-dimensional array, with the lower bound of subscripts in both dimensions starting from zero: CREATE TABLE SAMPLE_ARR2 ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [0:3, 0:3] ); The database employee fdb, found in the ../examples/empbuild directory of any Firebird distribution package, contains a sample stored procedure showing some simple work with arrays: Chapter 3. Data Types and Subtypes 55 3

........................................................................... 13 Connecting to the sample database .................................................................................... 13 server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners!) • Release notes – ESSENTIAL READING! only) \bin Command-line tools gbak.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee.gdb \ex- amples User-defined function (UDF) libraries ib_udf.dll

more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners). • Release notes – essential reading! Firebird /bin Command-line tools isql, gbak, nbackup, gsec, gfix, gstat, etc. /bin Sample database employee.fdb /examples/ empbuild UDF libraries ib_udf.so, fbudf.so /UDF Command-line tools isql.exe, gbak.exe, nback- up.exe, gsec.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee.fdb \examples\ empbuild User-defined function (UDF) li- braries ib_udf

$(install)/bin Plugins libEngine13.so, libSrp.so, libudr_engine.so, etc. $(install)/plugins Sample database employee.fdb $(install)/examples/empbuild Additional server- side libraries libib_util exe, etc. $(install) Plugins engine13.dll, srp.dll, udr_engine.dll, etc. $(install)\plugins Sample database employee.fdb $(install)\examples\empbuild Internationalisatio n fbintl.conf, fbintl.dll Refer to their documentation or online help to find out. 6.2. Connecting to an existing database A sample database named employee.fdb is located in the examples/empbuild subdirectory of your Firebird installation

any data type except BLOB and ARRAY. Chapter 3. Data Types and Subtypes 38 Example CREATE TABLE SAMPLE_ARR ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [4] ); This example will create a table two-dimensional array, with the lower bound of subscripts in both dimensions starting from zero: CREATE TABLE SAMPLE_ARR2 ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [0:3, 0:3] ); The DBMS does not offer fdb, found in the ../examples/empbuild directory of any Firebird distribution package, contains a sample stored procedure showing some simple work with arrays: PSQL Source for SHOW_LANGS, a procedure involving

реализованы на базе полей типа BLOB. Массивы могут быть одномерными и многомерными. CREATE TABLE SAMPLE_ARR ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [4]); с массивом размерности два, в котором нижняя граница значений начинается с нуля: CREATE TABLE SAMPLE_ARR2 ( Типы данных 47 ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [0:3, 0:3]); возвращаемого результата: DOUBLE PRECISION. Функция COVAR_SAMP возвращает выборочную ковариацию (sample covariance) пары выражений с числовыми значениями. Функция COVAR_SAMP(, ) эквивалентна

stores it in the file /opt/fire- bird/SYSDBA.password. 10. Adds an entry to aliases.conf for the sample database, employee.fdb. Installing on POSIX Platforms 37 Testing your Linux installation Step

the SET TRANSACTION command. Chapter 7. Getting Help 13 Chapter 8. Connecting To A Database A sample database named employee.fdb is located in the examples/empbuild subdirectory of your Firebird installation

eindimensional und mehrdimensional sein und jeden Datentyp außer BLOB und ARRAY haben. Beispiel CREATE TABLE SAMPLE_ARR ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [4] ); In diesem Beispiel wird eine Tabelle zweidimensionalen Array, wobei die Untergrenze der Indizes in beiden Dimensionen bei Null beginnt: CREATE TABLE SAMPLE_ARR2 ( Chapter 3. Datentypen und Untertypen 43 ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER ======= =================== SYSDBA Srp ALEX B x Srp ALEX C sample Srp SYSDBA Legacy_UserManager Anhang F: Sicherheitstabellen 691 Anhang G: Zeichensätze