Re: [ADMIN] Automatic null values convertion in INSERT and WHERE

2003-11-19 Thread Stephan Szabo
On Wed, 19 Nov 2003, Tomasz Spyrczak wrote: > I've just compiled PostgreSQL 7.4 and come across this problem: > > I have a table like this: > > CREATE TABLE test (field1 integer, field2 integer default 0); > > Then I want to insert some "empty" record like this: > > INSERT INTO test (field1, field

Re: [ADMIN] Automatic null values convertion in INSERT and WHERE statements

2003-11-19 Thread Bruno Wolff III
On Wed, Nov 19, 2003 at 11:00:25 +0100, Tomasz Spyrczak <[EMAIL PROTECTED]> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Then I want to insert some "empty" record like this: > > INSERT INTO test (field1, field2) VALUES ('', ''); > > My question is: how to "convince" PostgreS

[ADMIN] Automatic null values convertion in INSERT and WHERE statements

2003-11-19 Thread Tomasz Spyrczak
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there! I've just compiled PostgreSQL 7.4 and come across this problem: I have a table like this: CREATE TABLE test (field1 integer, field2 integer default 0); Then I want to insert some "empty" record like this: INSERT INTO test (field1, field