| From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
|---|---|
| To: | henrik(at)steffen(dot)stade(dot)net |
| Cc: | Mark Jewiss <mark(at)office(dot)knowledge(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? |
| Date: | 1999-05-13 11:49:23 |
| Message-ID: | Pine.LNX.4.04.9905130747080.23562-100000@dragosani.lan2wan.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Engard Ferenc | 1999-05-13 12:17:21 | Re: [SQL] Slow Inserts Leads To Unable To Dump |
| Previous Message | Henrik Steffen | 1999-05-13 11:14:15 | Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? |