db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Is there a POW (power) or COS function in derby
Date Mon, 07 Jan 2008 15:14:29 GMT
Hi Jay,

As Thomas points out, the builtin COS and EXP functions may be useful to 
you. If these functions don't give you what you need, you can always 
write your own function in Java and register it with Derby using the 
CREATE FUNCTION command. This command is described in the "SQL language 
reference" section of the Derby Reference Guide: 

Hope this helps,

Thomas Nielsen wrote:
> Hi Jay,
> You'll find a list of all the built-in functions, and specifics of 
> each, in the derby 10.3 reference manual
>   http://db.apache.org/derby/docs/10.3/ref/
> specifically in the topic "Built-in functions":
>   http://db.apache.org/derby/docs/10.3/ref/rrefsqlj29026.html
> Hope this helps!
> Cheers,
> Thomas
> Jayson Hay wrote:
>> Hi there,
>> I am wanting to move from using MySQL to derby embedded. One thing I 
>> have not been able to work out yet is how to use POW or COS in derby. 
>> Are these function even available? If not, is there a workaround that 
>> I could use?
>> Thanks
>> Jay

View raw message