Re: Select default values

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