Home > mailing lists

Re: null value in date field - Mailing list pgsql-novice

From	Josh Berkus
Subject	Re: null value in date field
Date	February 18, 2003 22:25:20
Msg-id	web-2846324@davinci.ethosmedia.com Whole thread Raw
In response to	null value in date field (Jeff Deroshia <jeff@hal.physast.uga.edu>)
Responses	Re: null value in date field
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Andrew McMillan
Date: 18 February 2003, 19:26:20
Subject: Re: Ordering rows in a table

From: Tom Lane
Date: 19 February 2003, 05:24:45
Subject: Re: base36 sequence

Re: null value in date field - Mailing list pgsql-novice

Previous

Next