Re: [GENERAL] Empty date field !

From: Christian Rudow <Christian(dot)Rudow(at)thinx(dot)ch>
To: Erik Colson <beaver(at)glo(dot)be>
Cc: PostgreSQL General <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL] Empty date field !
Date: 1999-07-07 08:38:45
Message-ID: 37831215.6F45E3BF@thinx.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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(dot)Rudow(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zeugswetter Andreas IZ5 1999-07-07 09:13:15 Re: [HACKERS] RE: [GENERAL] Transaction logging
Previous Message Bruce Momjian 1999-07-07 08:07:00 Re: [GENERAL] Problems with inequalities on numeric fields in 6.5