Re: varchar lengths - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: varchar lengths
Date
Msg-id AANLkTinywm-tHYaCH8TWD8p7zU+6SSPR25PsR=KyQKYa@mail.gmail.com
Whole thread Raw
In response to varchar lengths  (Marcus Engene <mengpg2@engene.se>)
Responses Re: varchar lengths  (Terry Lee Tucker <terry@chosen-ones.org>)
Re: varchar lengths  (Arjen Nienhuis <a.g.nienhuis@gmail.com>)
List pgsql-general
I recommend to use TEXT as type for that kind of columns.
99 out of 100 theories about "this value will never be longer then xx
characters" fail in the long run.

And "text", limited only by PostgreSQLs limits, performs as good or
better then varchar(length_limit) The time of "we only can allow n
chars for first name" for performance reasons have gone by, together
with walkmen and VHS.


Harald


--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: varchar lengths
Next
From: Terry Lee Tucker
Date:
Subject: Re: varchar lengths