Re: [GENERAL] Character fields and length

2006-09-21 Thread Chander Ganesan
Brandon Aiken wrote: 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 onl

[GENERAL] Character fields and length

2006-09-21 Thread Brandon Aiken
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 log