On Nov 17, 2012, at 20:43, John R Pierce <pie...@hogranch.com> wrote:
> On 11/17/12 5:37 PM, David Johnston wrote: >> On Nov 17, 2012, at 20:11, Jasen Betts<ja...@xnet.co.nz> wrote: >>> >On 2012-11-05, Moshe Jacobson<mo...@neadwerx.com> wrote: >>>> >>But more importantly, what's the practical difference between varchar >>>> >>with >>>> >>no limit and text? >>> >text is immeasurably faster. >> If it cannot be measured then how can you claim this? >> >> Everything I've heard says there is no difference between "varchar" and >> "text" as they are simply synonyms for the same underlying implementation. >> What makes you think differently? > > I think he meant a tiny tiny bit faster, primarily due to not having to > validate the length. > Maybe... But I would presume a "varchar with no limit" does not validate length... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
