Character fields and length

Поиск
Список
Период
Сортировка
От Brandon Aiken
Тема Character fields and length
Дата
Msg-id F8E84F0F56445B4CB39E019EF67DACBA2F2454@exchsrvr.winemantech.com
обсуждение исходный текст
Ответы Re: Character fields and length  (Chander Ganesan <chander@otg-nc.com>)
Список pgsql-general

I know that in PostgreSQL, there is no performance difference between character and character varying.  

 

Is there any penalty in either performance or disk space for not specifying a length on char and varchar fields?  Is it really just there only as a basic check constraint for the logical model?

 

--

Brandon Aiken

CS/IT Systems Engineer

 

Confidentiality Notice

This email, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed.  If the reader of this email is not the intended recipient or his/her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this email is prohibited.  If you have received this email in error, please notify the sender by replying to this message and deleting this email immediately.

 

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

Предыдущее
От: Terry Lee Tucker
Дата:
Сообщение: Re: After Trigger
Следующее
От: Michelle Konzack
Дата:
Сообщение: Re: vista