db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by jeanTanderson
Date Fri, 13 Jan 2006 00:32:47 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by jeanTanderson:
http://wiki.apache.org/db-derby/DerbySQLroutines

The comment on the change is:
Started adding sample SQL functions from the derby-user mail archives

------------------------------------------------------------------------------
  
  The [https://svn.apache.org/repos/asf/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/
Derby functional tests] are an excellent source for function samples.
  
+ Examples from the Derby mail archives include:
+ 
+  * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/%3c41C3584A.3080302@Source-Zone.Org%3e
A function without any parameters that returns an integer]
+  * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200506.mbox/%3C42A0E031.60003@bristowhill.com%3E
A function that takes two values, adds them together and returns the result; also shows how
to invoke a function in a trigger]
+  * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%3C43418926.6010407@sun.com%3E
A function that given a Date, returns the day of week]
+  * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200501.mbox/%3c41DAC70D.7000002@debrunners.com%3e
A function that converts a Timestamp to its corresponding Long value using Java]
  
  == Creating Procedures ==
  

Mime
View raw message