Re: Insert NULL for '' - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Insert NULL for ''
Date
Msg-id 3EEB4580.9050106@wildenhain.de
Whole thread Raw
In response to Re: Insert NULL for ''  (Mike Mascari <mascarm@mascari.com>)
Responses Re: Insert NULL for ''  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Hi,


Mike Mascari wrote:
...

>
>
> What would be really neat is the ability of CREATE CAST to override
> the default implementation and at the same time let the override call
> the "base" implementation, if necessary.

This is already possible: you just have to define your own
type which would behave like a date for all operations
but not for text2yourdate, which would then accept ''
for null as well.

Might be a little bit work, buts perfectly doable.

Regards
Tino


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Growing Database Size Solved
Next
From: Mike Mascari
Date:
Subject: Re: Insert NULL for ''