Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Empty date field ! - Mailing list pgsql-general

From Christian Rudow
Subject Re: [GENERAL] Empty date field !
Date
Msg-id 37831215.6F45E3BF@thinx.ch
Whole thread Raw
In response to Empty date field !  ("Erik Colson" <beaver@glo.be>)
List pgsql-general
Tree view 
> I'm desperately searching how to UPDATE a date-field with an empty
> value ?

use escape : \N (represents NULL)
Chris

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow                 E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services    Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Problems with inequalities on numeric fields in 6.5
Next
From: Zeugswetter Andreas IZ5
Date:
Subject: Re: [HACKERS] RE: [GENERAL] Transaction logging