Re: [GENERAL] Question about varchar and text

2005-01-06 Thread Joshua D. Drake
Derik Barclay wrote: 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. There is a theory that text is faster than varchar, because postgresql doesn't have to check text. S

Re: [GENERAL] Question about varchar and text

2005-01-06 Thread Thomas Braad Toft
Hi! 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. http://www.postgresql.org/docs/7.4/interactive/datatype-character.html Quote: "Tip: There are no performance differ

Re: [GENERAL] Question about varchar and text

2005-01-06 Thread Derik Barclay
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

[GENERAL] Question about varchar and text

2005-01-06 Thread Stewart, Robert D (COT)
Title: Question about varchar and text 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 3