integer and '' - Mailing list pgsql-novice

From Verena Ruff
Subject integer and ''
Date
Msg-id 200507092220.32742.lists@triosolutions.at
Whole thread Raw
Responses Re: integer and ''
List pgsql-novice
Hi,

I am using a php based application with postgresql and now I am in the
progress migrating to pg 8.0.x.

The problem is that this application produces statements like
INSERT INTO table (a, b) VALUES ('1', '')

where a and b are integers. This worked with pg7, but with pg8 I get an error:
invalid value for integer: ''

Is this a changed behaviour in the new version or is there just a parameter in
the config file I don't know?

Thanks in advance,
Verena

pgsql-novice by date:

Previous
From: "Michael Avila"
Date:
Subject: Coding An SQL Statement
Next
From: Bruno Wolff III
Date:
Subject: Re: integer and ''