Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? - Mailing list pgsql-sql

From Brett W. McCoy
Subject Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?
Date
Msg-id Pine.LNX.4.04.9905130747080.23562-100000@dragosani.lan2wan.com
Whole thread Raw
In response to Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?  (Henrik Steffen <webmaster@city-map.de>)
List pgsql-sql
On Thu, 13 May 1999, Henrik Steffen wrote:

> Thanks for you quick response.
> 
> I understand the difference between CHAR and VARCHAR now.
> 
> But, what is the difference between VARCHAR and TEXT ?

Text fields have no explicit upper limit.  They are kinda like memo
fields in Access, except you *can* index them in PostgreSQL.

Brett W. McCoy                                                  http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Never get into fights with ugly people because they have nothing to lose.



pgsql-sql by date:

Previous
From: Henrik Steffen
Date:
Subject: Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?
Next
From: Tom Lane
Date:
Subject: Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?