Josh Berkus <josh@agliodbs.com> wrote: > Wouldn't this require creating, for example, a SHORTTEXT type?
Yes, new types are required. There are no binary compatibility between them and existing variable length types (text, bytea, etc.). But 'SHORTTEXT' is not a proper name for them. They can represent long texts though they are optimized for short ones. We might be able to optimize types further if we create different types for each length, for example, tinytext for length < 256, shorttext for 64K, mediumtext for 16MB ... But I think this is not appropriate. It forces users to choose one from several text types and we will have to maintain them. > Or were you planning this to handle VARCHAR(6) and the like? If the new text type wins VARCHAR in many respects, I'd like to propose to replace VARCHAR with it. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---------------------------(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