According to http://www.postgresql.org/docs/8.0/interactive/datatype-character.html I always use TEXT, for column which store text so that I need not to worry on text length. However, in certain situation, I know that my text length will always < 10 characters I was wondering, if I using TEXT, will there have any overhead on (1) storage space? (2) query performance? (3) write performance? Shall I just use varchar(10) ? Thanks! Thanks and Regards Yan Cheng CHEOK -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
