Re: Question about varchar and text

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. So it is one less thing for PostgreSQL to do
before it provides the tuple.

J

>
> 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 RobertD(dot)Stewart(at)ky(dot)gov
>
>

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL