Thom Brown <thombrown@xxxxxxxxx> writes: > 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. "Extension" means "it's not in the SQL standard". It's not meant to imply anything about performance. There is some potential overhead from using varchar instead of text because of the extra dummy cast nodes that are likely to be present in your query expressions (since all the native functions are declared to take/return text, not varchar). In most cases I'd think you'd be hard-put to measure any difference though. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
