Custom functions in DDL for default column values ?

Giganews Newsgroups
Subject: Custom functions in DDL for default column values ?
Posted by:  Curmudgeon (richard.a.ellio…@williams.com)
Date: 28 Jan 2005

Is it possible to set a default for a colume to be a custom function ?

In other words instead of the function sysdate, could I write my own
function and set the default to myfunction ?

I know I can do something very similar in a trigger, but it's a lot
easier for me to change DDL than application trigger source code.

Replies