Change Notes item #794199, was opened at 2003-08-24 20:03
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=381174&aid=794199&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Priority: 5
Submitted By: Alexey Loubyansky (loubyansky)
Assigned to: Nobody/Anonymous (nobody)
Summary: Functions in SELECT clause
Initial Comment:
The following queries are the examples of the feature:
SELECT COUNT(b.id) FROM B AS b
SELECT SQRT(b.longField) FROM B AS b WHERE b.id = ?1
SELECT ABS(b.longField) FROM B AS b WHERE b.id = ?1
SELECT LCASE(b.name) FROM B AS b WHERE b.id = ?1
SELECT UCASE(b.name) FROM B AS b
SELECT LENGTH(b.name) FROM B AS b WHERE b.id = ?1
SELECT CONCAT('Dear ', b.name) FROM B AS b WHERE b.id = ?1
SELECT LOCATE('ice', b.name, 1) FROM B AS b WHERE b.id = ?1
SELECT SUBSTRING(b.name, 3, 5) FROM B AS b WHERE b.id = ?1
SELECT UCASE(SUBSTRING(CONCAT(b.id, b.name), 5, 7))
FROM B AS b WHERE b.id = ?1
If the result of a function is an integer value, the
result will be of type java.lang.Long. If the result is
real, then java.lang.Double is returned.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=381174&aid=794199&group_id=22866
-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
