Re: text .vs. varchar

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Martin Gainty <mgainty(at)hotmail(dot)com>
Cc: Bill Moran <wmoran(at)collaborativefusion(dot)com>, Joao Ferreira <jmcferreira(at)critical-links(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: text .vs. varchar
Date: 2008-08-13 16:10:35
Message-ID: 20080813161034.GA4672@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martin Gainty wrote:

> With Postgres appears that TEXT is preferred over varchar(N)
> http://archives.postgresql.org/pgsql-general/2006-03/msg01522.php

Implementation-wise, they are exactly the same, modulo length checking.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hunter 2008-08-13 16:41:41 Re: automatic REINDEX-ing
Previous Message Scott Marlowe 2008-08-13 15:06:15 Re: psql tutorial