On 6/8/05, K C Lau <[EMAIL PROTECTED]> wrote:
> Both keys are text fields. Does it make any difference if PlayerID were
> integer?
>
It can make a difference in speed and integrity. If the column is an
integer, the storage on disk could be smaller for the column and the
related indexes. If the the column is an integer, it would not be
possible to have a value like 'arbitrary value that looks nothing like
an integer'.
George Essig
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
