Skip site navigation (1) Skip section navigation (2)

integer and ''

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: integer and ''
Date: 2005-07-09 20:20:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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,


pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-07-09 23:06:23
Subject: Re: integer and ''
Previous:From: Michael AvilaDate: 2005-07-09 19:06:06
Subject: Coding An SQL Statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group