db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Help with Triggers
Date Mon, 07 Jun 2010 22:51:40 GMT
pb2208 <pete.beatty@gmail.com> writes:

> I understand I can use the generated column.  The real problem is the second
> scenario where a number must be assigned to one of several range values.

You can still use a generated column, but having the new value be
generated by a stored function containing the range logic, based on the
given column.

Hope this helps!


View raw message