I'd be suspect of choosing a PK whose type definition includes the word "inexact".
You also say you want to store the data as a double precision but you never actually explain what the natural key of the data is.
If you are strictly storing serial (big) integers but doing so within a double precision typed column you may be OK - but I would advise taking input from someone with more expertise on the properties of IEEE floating point numbers.
David J.
(Not an IEEE floating point expert, but...) I've learned the hard way to never rely on comparing two floating point numbers for equality -- and that's what you are doing if you join on them as primary keys. If you must use the underlying numeric data for joining, I'd recommend you do something like:
* output the value to a string (rounded to a specific number of digits)
* use the textual representation of the number as your primary key.
Alternatively, if the numbers are very large or very small, you may want to try converting the binary data into a BINHEX value and use that textual representation as the primary key.
Either way, I think you'd be saving yourself a lot of headaches using a representation that is not 'inexact.'
