Tue, 18 Dec 2012 15:15:41 -0800 (PST)
Received: by 10.50.5.174 with SMTP id t14mr1993997igt.11.1355872541437; Tue,
18 Dec 2012 15:15:41 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Tue, 18 Dec 2012 15:15:41 -0800 (PST)
Complaints-To: groups-abuse(at)google(dot)com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=67.217.89.1; posting-account=lOEuBgoAAAD6Qw4dpoqeBAJHKoD58tcK
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <6087737c-f946-4698-92f0-3ea72a56aa2b(at)googlegroups(dot)com>
Subject: question about varchar
From: Rui Li <rui(dot)vapps(at)gmail(dot)com>
Injection-Date: Tue, 18 Dec 2012 23:15:41 +0000
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
To: pgsql-general(at)postgresql(dot)org

In postgresql, we can create column as =93varchar(n)=94 where n is the size=
of the char, or we can just define column as =93varchar=94
rli=3D# CREATE TABLE test (v1 varchar(100), v2 varchar);
CREATE TABLE
rli=3D# \d test
Table "public.test"
Column | Type | Modifiers
--------+------------------------+-----------
v1 | character varying(100) |
v2 | character varying |

so my question is: why should we even declare character varying(n) in postg=
resql when there=92s an easier options to declaring character varying (with=
out n)=20
is there any performance different between it? or some other reason we shou=
ld use varchar(n) instead of just varchar?

thanks for any help