[Firebird-devel] how to declare a decfloat (16) with a scale of zero for a column GENERATED BY DEFAULT AS IDENTITY

[Norbert Saint Georges]

Hello,

can't an identity column be a decfloat (16)?

  RECREATE TABLE FIREBIRD_PARTS (
              PART_ID DECFLOAT (16) GENERATED BY DEFAULT AS IDENTITY 
not null
            , PART_NAME varchar (255) not null
            , BUY_PRICE decimal (9, 2)
);

error: 336068881

description found in client-java:

Identity column {0} of table {1} must be of exact number type with zero 
scale

--
Norbert Saint Georges
http://tetrasys.fi



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel