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.
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 |