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(at)archonet(dot)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
>