Re: integer and ''

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Verena Ruff <lists(at)triosolutions(dot)at>
Cc: Pgsql-Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: integer and ''
Date: 2005-07-09 23:06:23
Message-ID: 20050709230623.GA23292@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Søren Poulsen 2005-07-10 13:12:49 relation does not exist!?
Previous Message Verena Ruff 2005-07-09 20:20:32 integer and ''