Joshua D. Drake wrote:
Richard Huxton wrote:
http://www.thestar.com/News/article/189175
"For instance, in some cases the field for the social insurance number
was instead filled in with a birth date."
Unbelievable. Sixty years of electronic computing, fifty years use in
business and the "professionals" who built the tax system for a
wealthy democratic country didn't use data types.
This is Unbelievable? This is commonplace.
I need to start adding 10% on my fees for things like "use of types".
I would put some foreign-key constraints in my current project, but I
don't think the client can afford it ;-)
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
