Postgres Pro
Downloads
Home   >   mailing lists

Re: query configuration for validate empty quote to zero - Mailing list pgsql-sql

From Tom Lane
Subject Re: query configuration for validate empty quote to zero
Date
Msg-id 9227.1105989789@sss.pgh.pa.us
Whole thread Raw
In response to query configuration for validate empty quote to zero  ("Yudie" <yudie@axiontech.com>)
List pgsql-sql
Tree view 
"Yudie" <yudie@axiontech.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

pgsql-sql by date:

Previous
From: "Yudie"
Date:
Subject: query configuration for validate empty quote to zero
Next
From: Stephan Szabo
Date:
Subject: Re: plpgsql and for with integer loopvar error