Re: Limited varchar, unlimited varchar, or text? - Mailing list pgsql-general

From Greg Stark
Subject Re: Limited varchar, unlimited varchar, or text?
Date
Msg-id 878yqnpzef.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Limited varchar, unlimited varchar, or text?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I have myself been wondering if we couldn't converge the TEXT and
> VARCHAR types some more, but we're not likely to remove either one.

Can't we rip out all the code for, say, "text" and just treat "text" as an
alias for "varchar"?

That would make \d and pg_dump etc print "varchar" which might surprise users
but it would make it obvious that there really isn't any difference.

--
greg

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Postgres unique index checking and atomic transactions
Next
From: Richard Huxton
Date:
Subject: Re: SAP DB: The unsung Open Source DB