Обсуждение: RE: [HACKERS] empty dates and changing the default date behaviour

Поиск
Список
Период
Сортировка

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

От
Willy De la Court
Дата:
> Tom Lane [SMTP:tgl@sss.pgh.pa.us] wrote:
> Willy De la Court <Willy.DelaCourt@pandora.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".

Ok how do i do it with recompiling postgres I badly need this functionality.
I know some C programming but not enough to dive into the source of postgres.

any suggestions.