This is possible:

CREATE TABLE MyTable
ID INTEGER DEFAULT MyFunction(),
...

But this is not possible:

CREATE TABLE MyTable
ID INTEGER COMPUTED ALWAYS AS MyFunction(ID),
...

It would be BRILLIANT if it was possible. Sorry if this has been discussed before.

Adam,

<< But this is not possible:

CREATE TABLE MyTable
ID INTEGER COMPUTED ALWAYS AS MyFunction(ID),
..

It would be BRILLIANT if it was possible. Sorry if this has been discussed
before. >>

Use GENERATED instead.  COMPUTED expressions must be able to be evaluated on
the client-side, so they cannot contain other database schema object
references because the client-side does not have access to, or the ability
to deal with, complex evaluations like that.

Tim Young
Elevate Software
www.elevatesoft.com

>>Use GENERATED instead.  



thanks, this hugely simplifies some stuff for me!