Re: null value in date field

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Jeff Deroshia <jeff(at)hal(dot)physast(dot)uga(dot)edu>, pgsql-novice(at)postgresql(dot)org
Subject: Re: null value in date field
Date: 2003-02-19 00:25:30
Message-ID: web-2846324@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jeff,

> I have a form that contains optional DATE fields. To enter null
> values, I've tried null, 'null', '', '-', '0', 0, and each time I get
> one of the following errors:

NULL is correct, no quotes. Please post the actual insert statement
you are sending; likely the problem is elsewhere.

-Josh

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-02-19 07:24:43 Re: base36 sequence
Previous Message Keith Keller 2003-02-18 23:19:26 Re: null value in date field