On Tue, Aug 08, 2006 at 04:41:04PM -0400, Chris Hoover wrote: > I have the following table: <snip> > The reason for the null being passed to to_date is this is on of almot 90k > lines of data we are trying to load, and the script was built to generate > this code. Since to_date(null,'yyyymmdd') returns a null, why is the > default not working? If you try to insert a NULL into a not null column, you get an error. To trigger the default you either need to omit the column from the insert statement, or use the DEFAULT keyword. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
