Alien-DBD-SQLite-BundledExtensions
view release on metacpan or search on metacpan
lib/DBD/SQLite/BundledExtensions.pm view on Meta::CPAN
next characters (and thereby determine when keys should not be grayed
out) run the following query:
SELECT next_char('cha','dictionary','word');
IMPLEMENTATION NOTES:
The next_char function is implemented using recursive SQL that makes
use of the table name and column name as part of a query. If either
the table name or column name are keywords or contain special characters,
then they should be escaped. For example:
SELECT next_char('cha','[dictionary]','[word]');
This also means that the table name can be a subquery:
SELECT next_char('cha','(SELECT word AS w FROM dictionary)','w');
=item percentile
This file contains code to implement the percentile(Y,P) SQL function
( run in 0.355 second using v1.01-cache-2.11-cpan-c21f80fb71c )