On 24/lug/08, at 23:15, Richard Broersma wrote:
> On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti
> <giorgio_v@mac.com> wrote:
>
>>> Um - there is no default value for a function.
>>
>> Without this "feature" you have to overload
>> the function arguments.
>
> You could pass a casted null to the function. The would eliminate
> function overloading. Then internally you could handle the null by
> passing DEFAULTS to you INSERT or UPDATE statements. I don't know if
> this would work for you in this case.
It could work but only if I use a domain that allows NULLs, which
reduces the usefulness of domains even if you can work around that by
simply stating the not null clause in the table definition.
--
Giorgio Valoti