Re: integer and ''

On Sat, Jul 09, 2005 at 22:20:32 +0200,
Verena Ruff <lists(at)triosolutions(dot)at> wrote:
> 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?

Empty strings aren't valid integers. This was considered a bug in older
versions and fixed a couple of releases ago. Use either 0, NULL or DEFAULT
depending on what you expect that to do.