On Tuesday, December 18, 2012 at 10:15, Rui Li wrote:
/*
** text 'cleaned' to remove message digest cruft
** apologies for any errors
*/
In postgresql, we can create column as varchar(n)=94 where n is the
sizeof the char, or we can just define column as varchar=94
rli=3D# CREATE T
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
