From: "Good, Thomas" <TGood@svwsjmc.org>
To: Adam Cornett <adam.cornett@gmail.com>, "ktm@rice.edu" <ktm@rice.edu>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Fri, 14 Oct 2011 14:28:15 -0400
Subject: Re: Tripping over (my own) stupidity - VARCHAR declaration
	minus specificity
Thread-Topic: [SQL] Tripping over (my own) stupidity - VARCHAR declaration
	minus specificity
Thread-Index: AcyKnns74E2WTkSyR62q7yszD734mgAAI50C
Message-ID: <C3FA421FEED237488E9820D1ED668F330AB5ACE4@SVWEMAIL>
References: <C3FA421FEED237488E9820D1ED668F330AB5ACE3@SVWEMAIL>
	<CAB5sPxb7HotxjE9J-6hU6+hYy1RtOjQevUSfzdHGunZLW72DGw@mail.gmail.com>
	<20111014180919.GY10975@staff-mud-56-27.rice.edu>,
	<CAB5sPxZbF6RPdZdPVFhXYCmPf-mnHhkWit5LVe2PZPAo0EVF1A@mail.gmail.com>
In-Reply-To: 
 <CAB5sPxZbF6RPdZdPVFhXYCmPf-mnHhkWit5LVe2PZPAo0EVF1A@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Thanks guys - yes Adam it seems to behave exactly like text, at least in my=
 experience.
________________________________________
From: Adam Cornett [adam.cornett@gmail.com]
Sent: Friday, October 14, 2011 2:24 PM
To: ktm@rice.edu
Cc: Good, Thomas; pgsql-sql@postgresql.org
Subject: Re: [SQL] Tripping over (my own) stupidity - VARCHAR declaration m=
inus specificity

On Fri, Oct 14, 2011 at 2:09 PM, ktm@rice.edu<mailto:ktm@rice.edu> <ktm@ric=
e.edu<mailto:ktm@rice.edu>> wrote:
On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote:
> On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <TGood@svwsjmc.org<mailto:T=
Good@svwsjmc.org>> wrote:
>
> > I created a table in a hurry and forgot to specify the max capacity for=
 a
> > varchar() data type.
> > Can it be said what the max would be in a case like this (just curious)=
?
> >
> > thanks much
> >
>
> According to
> http://www.postgresql.org/docs/current/static/datatype-character.html,
> "If character varying is used without length specifier, the type accepts
> strings of any size. The latter is a PostgreSQL extension."
>
> -Adam Cornett

And according to the documentation, the maximum size of a varchar is
1GB.

Regards,
Ken

Yes, 1GB is the limit for any column size.  From what I can tell a varchar =
without a size specified acts just like text.

-Adam

This e-mail and any files transmitted with it are confidential and are inte=
nded solely for the use of the individual or entity to who they are address=
ed. This communication may contain protected health information and/or mate=
rial protected by the attorney-client privilege. If you are not the intende=
d recipient or the person responsible for delivering the e-mail to the inte=
nded recipient, be advised that you have received this e-mail in error and =
that any use, dissemination, forwarding, printing, or copying for this e-ma=
il is strictly prohibited. if you have received this e-mail in error, pleas=
e delete the message and attachments and notify the sender immediately.