The reason I ask is because the documentation says "If character varying is used without length specifier, the type accepts strings of any size. The latter is a PostgreSQL extension." I wasn't sure if such an extension meant there was a level of over-head involved, or reduced its indexability.
2009/1/27 Richard Huxton
<dev@archonet.com>Thom Brown wrote:
> Is there a real difference between a varchar without a specified length and
> the text datatype?
No.
Wish all questions were that easy :-)
--
Richard Huxton
Archonet Ltd