On 24/lug/08, at 23:15, Richard Broersma wrote:

On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti <[EMAIL PROTECTED]> 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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to