Re: another foreign key question - Mailing list pgsql-general

On Wed, 19 Dec 2001, Adam Fisher wrote:

> alter table invhistory
> add constraint fk_invhist_invid_inventory
> foreign key ("invid") references "inventory" ("invid")

Wasn't there something about foreign keys having to be of the same data
type?  (This pops to mind without doing a search of the archives)  The
inventory table is using integer (INT4?) and the invhistory uses
NUMERIC(14,0).  Seems a cast between types will be some extra overhead.
Isn't NUMERIC what was called BCD (binary coded decimal)
in-the-olden-days.


Rod
--
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler