Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D4820476101
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 09:01:08 -0400 (EDT)
Received: from spirit.aldeiadigital.com.br
	(iplus-fac-138.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.138])
	by postgresql.org (Postfix) with ESMTP id A09814760B0
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 09:01:06 -0400 (EDT)
Received: from aldeiadigital.com.br (localhost.localdomain [127.0.0.1])
	by spirit.aldeiadigital.com.br (8.11.6/8.11.4) with SMTP id
	g9GBvIe25186
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 09:57:18 -0200
Received: from 200.225.214.1 (proxying for 192.168.1.204)
	(SquirrelMail authenticated user alepaes)
	by webmail.ad2.com.br with HTTP;
	Wed, 16 Oct 2002 09:57:18 -0200 (BRST)
Message-ID: <1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br>
Date: Wed, 16 Oct 2002 09:57:18 -0200 (BRST)
Subject: pg_atoi() error
From: "alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS-perl11-milter (http://amavis.org/)
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/174
X-Sequence-Number: 9891

Hi,

Table xxx:

(...)
CPF numeric(11,0)
(...)

Select x,y,CPF from xxx where CPF='12345678901'

Generate the error:

error reading "12345678901": Numerical result out of range

The corversor recognize the 'number' like a integer and not like a numeric
type ???

I use Win ODBC-7.2.00.3 and Post-7.2.2

Thanks all,


Alexandre