Re: [ADMIN] varchar vs text columns

2007-07-24 Thread Lew
Andrew Sullivan wrote: On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote: What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? From the manual: Tip: There are no perform

Re: [ADMIN] varchar vs text columns

2007-07-23 Thread Peter Eisentraut
Jessica Richard wrote: > What is the difference between varchar and text for a string column? Nothing, if you don't use a limit for varchar. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/re

Re: [ADMIN] varchar vs text columns

2007-07-23 Thread Andrew Sullivan
On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote: > What is the difference between varchar and text for a string column? > What is the benefit of using each one? > Is text better than varchar performance wise? >From the manual: Tip: There are no performance differences bet

[ADMIN] varchar vs text columns

2007-07-23 Thread Jessica Richard
What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? Thanks. - Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto G