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
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
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
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