Subject Re: [firebird-support] stored procedure for a computed field?
Author Thomas Steinmaurer

> I have a stored procedure to calculate an indication of a record's age.
> It return "over 100 days ago" or "over 3 months ago" or ... Call it
> GetAgeMsg(myTS).
> Can I use a stored procedure to calculate a computed field for FB 2.5.x?
> If so what is the syntax?

As Martijn has pointed out, it is definitely possible. ;-)

But to be on the safe side, I would try a backup/restore cycle with gbak
to see if that SP dependency in a COMPUTED BY field causes troubles from
a dependency POV.

AFAIR, this has been fixed in 2.1, but I would give gbak a test-drive on
that, otherwise you might end up with non-working backups.

Just a thought.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.