-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/15/06 07:50, Martijn van Oosterhout wrote: > On Fri, Dec 15, 2006 at 07:44:16AM -0600, Ron Johnson wrote: >>> The difference in performence will be determined by the cost of >>> comparison. The cost of comparing strings is much higher than for >>> integers, so it will be slower. >> And comparing INT8 is more expensive on a 32-bit system. > > The difference between int4 and int8 is probably negligable. Probably compiler-dependent... >> Since TEXT is totally variable, is there a big difference in TEXT vs >> CHAR(8)? > > Nothing measurable I'd think. It's probably the same code. > > Have a nice day, - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFgq6KS9HxQb37XmcRAlE6AJ9LxzCHq95wggefa0Q4a6/sBAw7aACgyasp t8qCwkdarDlhc2N8PKkprrY= =BBBp -----END PGP SIGNATURE-----
