I don't know about running faster, but I believe the only difference between the two in postgres is that a varchar has a limit on input. They are stored and indexed the same.
On January 6, 2005 12:25 pm, Stewart, Robert D (COT) wrote: > What is the difference between varchar and text? > I have heard that you can use text instead of varchar and this could speed > up your tables. > > > Robert Stewart > Network Eng > Governor's Office of Technology > 101 Cold Harbor > Work # 502 564 9696 > Cell # 502 330 5991 > Email [EMAIL PROTECTED] -- Givex - http://www.givex.com/ Derik Barclay <[EMAIL PROTECTED]>, Systems Software Engineer +1 416 350 9660 +1 416 250 9661 (fax) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
