9 Sep
2004
9 Sep
'04
5:57 p.m.
At 9/9/04 3:49 AM, Peter Gervai wrote:
...that reminded me to ask about whether it's good to use fixed length varchar under postgres when the docs advise using text?
Yes, that's okay. The types "text" and "varchar" are treated almost identically by PostgreSQL, except that varchar enforces a maximum length (which can actually be good in some cases, to prevent something from accidentally inserting 1 MB of data into an "e-mail address" field, for example). There's no speed or storage space difference. -- Robert L Mathews, Tiger Technologies http://www.tigertech.net/ "Ignorance more frequently begets confidence than does knowledge." -- Darwin