Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 69C5FB5DBC2 for ; Fri, 14 Oct 2011 14:34:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 09457-01 for ; Fri, 14 Oct 2011 17:34:05 +0000 (UTC) X-Greylist: delayed 00:06:39.837702 by SQLgrey-1.8.0-rc2 Received: from mail85.messagelabs.com (mail85.messagelabs.com [216.82.241.211]) by mail.postgresql.org (Postfix) with ESMTP id 21EB1B5DC95 for ; Fri, 14 Oct 2011 14:34:05 -0300 (ADT) X-Env-Sender: TGood@svwsjmc.org X-Msg-Ref: server-7.tower-85.messagelabs.com!1318613244!35775002!1 X-Originating-IP: [69.195.41.67] X-StarScan-Version: 6.3.6; banners=-,-,- X-VirusChecked: Checked Received: (qmail 23169 invoked from network); 14 Oct 2011 17:27:24 -0000 Received: from unknown (HELO mail.svwsjmc.org) (69.195.41.67) by server-7.tower-85.messagelabs.com with AES128-SHA encrypted SMTP; 14 Oct 2011 17:27:24 -0000 Received: from SVWEMAIL.svwestj.local ([172.22.80.151]) by SVWEMAIL ([172.22.80.151]) with mapi; Fri, 14 Oct 2011 13:27:24 -0400 From: "Good, Thomas" To: "pgsql-sql@postgresql.org" Date: Fri, 14 Oct 2011 13:27:23 -0400 Subject: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Thread-Topic: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Thread-Index: AQHMipaJF7jEa0f77kC+hrqwLvLilQ== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.4 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FROM_DOMAIN_NOVOWEL=0.5 X-Spam-Level: X-Archive-Number: 201110/16 X-Sequence-Number: 35900 I created a table in a hurry and forgot to specify the max capacity for a v= archar() 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=FCcksmaschinen." - Peter Hein 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.