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@xxxxxxxxxxxx>
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
