pg_atoi() error - Mailing list pgsql-sql

From alexandre :: aldeia digital
Subject pg_atoi() error
Date
Msg-id 1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br
Whole thread Raw
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Ian Barwick
Date:
Subject: Re: replace null with 0 in subselect ?
Next
From: Domoszlai László
Date:
Subject: Re: set difference