X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1784FD1D55A for ; Thu, 26 Feb 2004 15:23:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 68721-02 for ; Thu, 26 Feb 2004 11:23:48 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 91B75D1BA9F for ; Thu, 26 Feb 2004 11:23:43 -0400 (AST) Received: (qmail 11918 invoked by uid 500); 26 Feb 2004 15:26:08 -0000 Date: Thu, 26 Feb 2004 09:26:08 -0600 From: Bruno Wolff III To: Edmund Bacon Cc: pgsql-sql Subject: Re: Scalar in a range (but textual not numeric) Message-ID: <20040226152608.GA19652@wolff.to> Mail-Followup-To: Edmund Bacon , pgsql-sql References: <200402251918.20289.dev@archonet.com> <1077807314.5760.11.camel@elb_lx.onesystem.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1077807314.5760.11.camel@elb_lx.onesystem.ca> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/366 X-Sequence-Number: 17056 On Thu, Feb 26, 2004 at 07:55:14 -0700, Edmund Bacon wrote: > On Wed, 2004-02-25 at 12:18, Richard Huxton wrote: > > As a complete aside: > > Is there any advantage to use varchar instead of type text? Only if there is a business rule that limits the length of the data.