Re: Difference between VARCHARs

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <Robert(dot)Farrugia(at)go(dot)com(dot)mt>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Difference between VARCHARs
Date: 2002-03-11 19:04:43
Message-ID: Pine.LNX.4.30.0203111403580.690-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robert(dot)Farrugia(at)go(dot)com(dot)mt writes:

> What difference does it make between declaring a field as VARCHAR(N) where
> N is an integer and declaring it just VARCHAR without giving the length ?

The former has a length limit, the latter doesn't.

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/datatype-character.html

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2002-03-11 19:22:41 Re: OIDs / noOIDs tables?
Previous Message Bruce Momjian 2002-03-11 19:00:19 Re: OIDs / noOIDs tables?