You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Rick Hillegas <Ri...@Sun.COM> on 2008/01/07 16:14:29 UTC
Re: Is there a POW (power) or COS function in derby
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:
http://db.apache.org/derby/docs/10.3/ref/
Hope this helps,
-Rick
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
>