pg_atoi() error

From: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: pg_atoi() error
Date: 2002-10-16 11:57:18
Message-ID: 1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2002-10-16 12:16:08 Re: replace null with 0 in subselect ?
Previous Message Ludwig Lim 2002-10-16 11:40:43 Locking that will delayed a SELECT