Home > mailing lists

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

From	Yudie
Subject	query configuration for validate empty quote to zero
Date	January 17, 2005 21:47:30
Msg-id	000d01c4fcc4$90fc9b40$a101a8c0@home.axiontech.com Whole thread Raw
Responses	Re: query configuration for validate empty quote to zero (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

We just changed the postgresql server and got some problem with sql command

in our old server we can exexute this query:

SELECT * FROM product WHERE prdtnumber = ''

field prdtnumber data type is integer and the empty quote somehow can be assumed into 0 (zero)

Now, if I use the same query it return an error:

invalid input syntax for integer: ""

Anyone know what's the problem??

Thanks

Yudie

From: Ari Kahn
Date: 17 January 2005, 21:19:58
Subject: plpgsql and for with integer loopvar error

From: Tom Lane
Date: 17 January 2005, 22:23:48
Subject: Re: query configuration for validate empty quote to zero