Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity

On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <TGood(at)svwsjmc(dot)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
>
> --
> Thomas A. Good, Senior Database Administrator
> Saint Vincent's Hospital Westchester
> A Division of Saint Joseph's Medical Center
> Residential Services
> 1216 Bay Street, Room L-8
> Staten Island, NY 10305
> 718.982.4752
>
> "Wir leben, wir sind Glücksmaschinen." - Peter Hein
>
> This e-mail and any files transmitted with it are confidential and are
> intended solely for the use of the individual or entity to who they are
> addressed. This communication may contain protected health information
> and/or material protected by the attorney-client privilege. If you are not
> the intended recipient or the person responsible for delivering the e-mail
> to the intended recipient, be advised that you have received this e-mail in
> error and that any use, dissemination, forwarding, printing, or copying for
> this e-mail is strictly prohibited. if you have received this e-mail in
> error, please delete the message and attachments and notify the sender
> immediately.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

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