Re:The Advantages of Flexible Typing
by zepolen on Sunday September 05, 2021 @09:16AM
(#28424121)
Author is talking about data errors vs type errors.
Data errors will always pass through regardless if it's invalid. Eg. an application bug that overflowed the int will still be happily accepted into an integer typed column even with a check contraint value > 0.
In the ANYTHING case you would have something like -205 in there instead.
For what it's worth I don't really agree with this post at all though.
Data errors will always pass through regardless if it's invalid. Eg. an application bug that overflowed the int will still be happily accepted into an integer typed column even with a check contraint value > 0.
In the ANYTHING case you would have something like -205 in there instead.
For what it's worth I don't really agree with this post at all though.