Firebird supports both fixed (exact precision) decimal and floating-point (approximate precision) number types. Fixed decimal types are the zero-scaled integer types SMALLINT, INTEGER and, in dialect 3, BIGINT, and two nearly identical scaled numeric types, NUMERIC and DECIMAL. The two floating-point types are FLOAT (single precision) and DOUBLE PRECISION.1


Double Precision Number Type Decimal Point Check Constraint Integer Type 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Helen Borrie and IBPhoenix 2004

Authors and Affiliations

  • Helen Borrie
    • 1
  1. 1.FirebirdSQL Foundation Inc.Australia

Personalised recommendations