Re: [HACKERS] empty dates and changing the default date behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Willy De la Court <Willy(dot)DelaCourt(at)pandora(dot)be>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] empty dates and changing the default date behaviour
Date: 2000-03-01 20:23:47
Message-ID: 24979.951942227@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Willy De la Court <Willy(dot)DelaCourt(at)pandora(dot)be> writes:
> I want to change the default behaviour of the data_in function without
> recompiling postgres. the functionality is the following.

> create table test (d date);
> insert into test values ('');

> this should result in the field d containing NULL and the insert
> command should work without returning an error.

Not possible at present, since a datatype's typinput function can't
return a NULL. I suppose it will be possible after we redo the
function manager interface, but in any case you'd have no hope of
changing the behavior "without recompiling postgres".

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2000-03-01 20:24:34 Re: [HACKERS] Re: NOT {NULL|DEFERRABLE} (was: bug in 7.0)
Previous Message Adriaan Joubert 2000-03-01 20:23:27 Re: bit types