Character fields and length

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Character fields and length
Date: 2006-09-21 17:52:29
Message-ID: F8E84F0F56445B4CB39E019EF67DACBA2F2454@exchsrvr.winemantech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chander Ganesan 2006-09-21 18:35:36 Re: Character fields and length
Previous Message Terry Lee Tucker 2006-09-21 17:00:14 Re: After Trigger