Re: query configuration for validate empty quote to zero

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yudie" <yudie(at)axiontech(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: query configuration for validate empty quote to zero
Date: 2005-01-17 19:23:09
Message-ID: 9227.1105989789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Yudie" <yudie(at)axiontech(dot)com> writes:
> Now, if I use the same query it return an error:
> invalid input syntax for integer: ""

> Anyone know what's the problem??

None. That's an intentional change. The fact that it ever accepted
'' as meaning 0 was a bug.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yudie 2005-01-17 19:30:03 Re: query configuration for validate empty quote to zero
Previous Message Yudie 2005-01-17 18:44:20 query configuration for validate empty quote to zero