Home > mailing lists

Re: text vs varchar - Mailing list pgsql-sql

From	Josh Berkus
Subject	Re: text vs varchar
Date	June 18, 2002 22:22:17
Msg-id	200206181559.54654.josh@agliodbs.com Whole thread Raw
In response to	text vs varchar (Wei Weng <wweng@kencast.com>)
Responses	Re: text vs varchar (Wei Weng <wweng@kencast.com>) Re: text vs varchar (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Wei Weng
Date: 18 June 2002, 21:33:50
Subject: text vs varchar

From: Rudi Starcevic
Date: 18 June 2002, 22:36:38
Subject: date_part

Re: text vs varchar - Mailing list pgsql-sql

Previous

Next