pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
To: pgsql-sql@postgresql.org
Subject: pg_atoi() error
Date: Wed, 16 Oct 2002 09:57:18 -0200 (BRST)
Message-ID: <1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br> (raw)

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

view thread (3+ messages)

Message-ID: <1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br>
Permalink:  ../1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br/
Also on:    postgresql.org/message-id/1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alepaes@aldeiadigital.com.br
  Subject: Re: pg_atoi() error
  In-Reply-To: <1325.200.225.214.1.1034769438.squirrel@webmail.ad2.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox