DEV Community

Discussion on: Data type mismatch in referential integrity and its implications

Collapse
 
bruceoutdoors profile image
Lee Zhen Yong • Edited

Never realise you can write a query for these mismatches. Good stuff. Though I think postgres ought to implement some setting to block this behaviour.

Collapse
 
bolajiwahab profile image
Bolaji Wahab

SQL implementation allows such behavior so postgres is just following the implementation.