NAME

Genezzo::Havok::SQLScalar - scalar SQL functions

SYNOPSIS

DESCRIPTION

ARGUMENTS

FUNCTIONS

perl functions

chomp

chop

chr

crypt

index

lc

lcfirst

length

ord

pack

reverse

rindex

sprintf

substr

uc

ucfirst

abs

atan2

cos

exp

hex

int

log10

oct

rand

sin

sqrt

srand

perl_join

SQL string functions

concat

greatest

initcap

least

lower

upper

SQL math functions

cosh

ceil

floor

ln

sinh

tan

tanh

SQL conversion functions

ascii

instr

nvl

Genezzo functions

quurl

quurl2

unquurl

EXPORT

LIMITATIONS

In Perl, "log" is a natural log, but the standard SQL log function is log base 10. To prevent confusion in usage, Genezzo supplies a natural log function "ln" and a base 10 function "log10".

instr needs to handle "occurrence".

The following standard functions are not implemented:

mod

power

round

sign

trunc

lpad

ltrim

replace

rpad

rtrim

soundex

translate

AUTHOR

Jeffrey I. Cohen, jcohen@genezzo.com

SEE ALSO

perl(1).

Copyright (c) 2005, 2006 Jeffrey I Cohen. All rights reserved.

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

Address bug reports and comments to: jcohen@genezzo.com

For more information, please visit the Genezzo homepage at http://www.genezzo.com