Re: Varchar vs varchar(64) - Mailing list pgsql-general

From Tom Lane
Subject Re: Varchar vs varchar(64)
Date
Msg-id 27391.1224608477@sss.pgh.pa.us
Whole thread Raw
In response to Re: Varchar vs varchar(64)  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:
> Rob Richardson wrote:
>> Are there other reasons to use
>> varchar(64) instead of varchar?

> You can't have "varchar" without a length in parentheses,
> as far as I know.

That's what the spec says and that's what some other implementations
require, but not Postgres.  We treat varchar without a length as pretty
much just an alias for text.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: How to free disk space
Next
From: Tom Lane
Date:
Subject: Re: exposing more parse was: Re: tsearch2: setting weights on tsquery