Postgres Pro
Downloads
Home   >   mailing lists

Thread: Difference between VARCHARs

Difference between VARCHARs

From
Robert.Farrugia@go.com.mt
Date:
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 ?

Regards
Robert

Re: Difference between VARCHARs

From
Peter Eisentraut
Date:
Robert.Farrugia@go.com.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@gmx.net