| Subject | Re: [ib-support] OID: Double or String? |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-08-29T00:35:15Z |
At 03:22 PM 28-08-02 -0500, you wrote:
anomalies. Use a generated 64-bit integer for number keys. If you need
leading zeros, apply a Before Insert trigger to get a generated number and
massage it into the string you need to store.
Ideally, don't use a meaningful value for the PK at all.
heLen
>For Interbase, what data type is more efficient forDouble is not a recommended type to use for keys, because of precision
>primary keys ? double or string?
anomalies. Use a generated 64-bit integer for number keys. If you need
leading zeros, apply a Before Insert trigger to get a generated number and
massage it into the string you need to store.
Ideally, don't use a meaningful value for the PK at all.
heLen