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