> Frankly, the only reason to use anything other than TEXT is
> compatibility with other databases and applications.

The main reason why I am still using VARCHAR rather than TEXT in many
places is to ensure that the column can be indexed. Postgres, it seems,
refuses to insert a string that is longer than some value into an
indexed column, and I'll rather have such errors flagged while inserting
a row rather than while rebuilding an index after having inserted lots
of rows.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to