X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 558914758F1 for ; Sat, 22 Feb 2003 11:53:56 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 87324-02 for ; Sat, 22 Feb 2003 11:53:45 -0500 (EST) Received: from lale.trnet.com (lale.tr.net [195.155.1.6]) by postgresql.org (Postfix) with ESMTP id 223E64758DC for ; Sat, 22 Feb 2003 11:53:45 -0500 (EST) Received: from [192.168.1.250] ([195.155.154.10]) by lale.trnet.com (InterMail vK.4.02.00.09 201-232-116-109 license 0f5baaa7065154cd09644893d36baf5e) with ESMTP id <20030222164130.XTKV21120.lale@[195.155.154.10]> for ; Sat, 22 Feb 2003 18:41:30 +0200 Subject: Re: updating integer column From: Devrim GUNDUZ To: PostgresPHP In-Reply-To: <20030222160726.91848.qmail@web10410.mail.yahoo.com> References: <20030222160726.91848.qmail@web10410.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 (1.0.8-10) Date: 22 Feb 2003 18:56:20 +0200 Message-Id: <1045932981.3428.6.camel@localhost.localdomain> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/45 X-Sequence-Number: 1896 Hi, On Sat, 2003-02-22 at 18:07, Bruce Young wrote: > how can i get around this.. It requires an integer; AFAIK you can't insert blank value there. > oh and what is the best datatype to use for a 10 digit phone number?. I always use char type for phone numbers. I think you don't need int column type. Do you make calculations with the numbers? ;) Best regards, -- Devrim GUNDUZ www.gunduz.org