Re: Newbee question "Types"

Ken,

1. Using column type "char" vs "varchar" vs "text"
   I understand the documented differences, but Why wouldn't
   someone just use varchar(x) instead of plain char(x)? It's
   definitely more flexable. Or would using char(x) just help one
   stay in sql conformity? How about performance differences?
   Disk space differences? Would not varchar(45) vs char(45)
   consume less space if used with less than 45 characters?

In postgresql, CHAR is supplied for 3 reasons:
1) For compatibility with other database systems that use CHAR.
2) For SQL99 Compliance
3) For compatibility with software that expects space-filled CHAR
fields.

For a Postgres-native application, there is no reason to ever use CHAR.
 It does not perform any better, and can lead to significant annoyance.

-Josh Berkus