Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Date: Mon, 07 Jan 2008 07:14:29 -0800
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: Is there a POW (power) or COS function in derby
In-reply-to: <4770DD6C.6050600@sun.com>
Sender: Richard.Hillegas@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <478241D5.7000000@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <4770BFDD.4010801@lizzy.com.au> <4770DD6C.6050600@sun.com>
User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031)

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
>