Re: text vs varchar

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Wei Weng <wweng(at)kencast(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: text vs varchar
Date: 2002-06-18 22:59:54
Message-ID: 200206181559.54654.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wei,

> Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
> datatype with a maximum length, especially when I do searches on them?

Yes. You can't index TEXT because it's of potentially unlimited length.

--
-Josh Berkus

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2002-06-18 23:19:45 date_part
Previous Message Wei Weng 2002-06-18 22:07:40 text vs varchar