Re: varchar lengths
От | Massa, Harald Armin |
---|---|
Тема | Re: varchar lengths |
Дата | |
Msg-id | AANLkTinywm-tHYaCH8TWD8p7zU+6SSPR25PsR=KyQKYa@mail.gmail.com обсуждение исходный текст |
Ответ на | varchar lengths (Marcus Engene <mengpg2@engene.se>) |
Ответы |
Re: varchar lengths
Re: varchar lengths |
Список | 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 по дате отправления: