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 _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
