X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A0F9552A79 for ; Wed, 17 Aug 2005 07:46:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43230-01 for ; Wed, 17 Aug 2005 10:46:04 +0000 (GMT) Received: from web52703.mail.yahoo.com (web52703.mail.yahoo.com [206.190.48.226]) by svr1.postgresql.org (Postfix) with SMTP id 45D6E52A14 for ; Wed, 17 Aug 2005 07:46:03 -0300 (ADT) Received: (qmail 76271 invoked by uid 60001); 17 Aug 2005 10:46:05 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Message-ID:Received:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding; b=6F2NZYHe4RcvUtwbCoKUmNBzy+xn8b9cVuL174lGDxzD5ZIZyX5+pmxpSJ0nimary+G2wL63d3SGVHswp3eVnpRIQU4M+ZlYE6JhBiZjIix9tXEhgnrvk30y3SpuMx70d/KAQjndfaehKCOXf2SD1aRUzsWz+oQ+mbDr4SEbg/E= ; Message-ID: <20050817104605.76269.qmail@web52703.mail.yahoo.com> Received: from [201.8.93.152] by web52703.mail.yahoo.com via HTTP; Wed, 17 Aug 2005 07:46:05 ART Date: Wed, 17 Aug 2005 07:46:05 -0300 (ART) From: Halley Pacheco de Oliveira Subject: Re: converting varchar to integer To: pgsql-sql@postgresql.org Cc: tv@fuzzy.cz MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.482 required=5 tests=[AWL=-0.099, DNS_FROM_RFC_ABUSE=0.374, UPPERCASE_25_50=0.207] X-Spam-Level: X-Archive-Number: 200508/121 X-Sequence-Number: 22349 Using CASE to avoid '': CREATE TABLE test (number TEXT); INSERT INTO test VALUES('123'); INSERT INTO test VALUES('a123b'); INSERT INTO test VALUES(''); teste=> SELECT CASE number WHEN '' THEN NULL ELSE to_number(number,'999999999999990') END AS number FROM test;; number -------- 123 123 (3 lines) __________________________________________________ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/