diff b/w varchar(N) & text

Поиск
Список
Период
Сортировка
От sathiya psql
Тема diff b/w varchar(N) & text
Дата
Msg-id f966c2ee0903170402o18423f43jc2ea86da6e8decd5@mail.gmail.com
обсуждение исходный текст
Ответы Re: diff b/w varchar(N) & text  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-sql
Hi.,<br /><br />Is there any big difference between selecting the data type as varchar(N) and text. What is the
differenceof it when seeing from the performance side ?<br /><br />I know that, when we know that the number of
characterwill not exceed N, we can use the varchar as datatype. If we dont know we can use this text as datatype. But
otherthan this anyother difference is there, and particularly in performance, and also if the number of rows crosses
100thousand... Any other views ?<br /><br />Any advise on this is appreciated.<br /><br />Thanks & Regards<br
/>SathiyaMoorthy. 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Gianvito Pio
Дата:
Сообщение: Methods declaration
Следующее
От: sathiya psql
Дата:
Сообщение: Re: Exclude fields from SELECT command