Although, to answer your question. yes it does:
http://www.h2database.com/html/features.html#user_defined_functions
eg:
CREATE ALIAS NEXT_PRIME AS $$
String nextPrime(String value) {
return new BigInteger(value).nextProbablePrime().toString();
}
$$;
On 23 May 2016 at 08:25, Kerry Sainsbury <[email protected]> wrote:
> Six years ago (gasp!) I wrote a patch for H2 that did this. You can read
> the conversation here
> <https://groups.google.com/forum/#!topic/h2-database/IKk5NqrCCTs>.
>
> Weirdly, I can't remember what happened in the end, or why it never got
> merged into trunk. I feel like a new project, so maybe I'll take another
> crack at it. I still think it's useful.
>
> On 20 May 2016 at 19:16, Suresh Prajapati <[email protected]>
> wrote:
>
>> Does H2 database support SQL user defined function (which is say 50 lines
>> of code etc..) without converting such function in java method?
>>
>>
>>
>>
>> On Thursday, April 7, 2011 at 11:31:54 PM UTC+5:30, Alex Feng wrote:
>>>
>>> Does H2 allow you to create user defined functions within the
>>> database?
>>>
>>> I want to do something like this:
>>>
>>> insert into table1 values ('key1',to_date('MM/DD/YYYY','10/10/2011');
>>>
>>> instead of changing all my code to replace the "to_date" function, I
>>> want to write something in H2
>>> that does the same thing as the Oracle to_date.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at https://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
