Login Register Actian.com  

Actian Community Wiki

Navigation
Learn About
Developing With
Ingres Talk
Information
Toolbox

Ingres DBMS function list

From Ingres Community Wiki

Jump to: navigation, search

Contents

[edit]

Introduction

This page contains a list of function names and their signatures that can be issued in an SQL query. Credits go to Ray Fan who published an article in his blog on using the Ingres Management Architecture (IMA) to extract this information from the server. 

select
    a.name,
    case when a.type='COMPARISON' then
        trim(iitypename(b.dtresult)) + ' = ( ' +
        trim(iitypename(b.dtarg1)) + ' ' +
        a.name + ' ' +
        trim(iitypename(b.dtarg2)) + ' )'
        when a.type='OPERATOR' then
        trim(iitypename(b.dtresult)) + ' = ( ' +
        trim(iitypename(b.dtarg1)) + ' ' +
        a.name + ' ' +
        trim(iitypename(b.dtarg2)) + ' )'
    else
        trim(iitypename(b.dtresult)) + ' = ' +
        a.name + '( ' +
            case when b.dtarg1 != '' then trim(iitypename(b.dtarg1)) else '' end +
            case when b.dtarg2 != '' then ', ' + trim(iitypename(b.dtarg2)) else '' end +
            case when b.dtarg3 != '' then ', ' + trim(iitypename(b.dtarg3)) else '' end +
            case when b.dtarg4 != '' then ', ' + trim(iitypename(b.dtarg4)) else '' end
        + ' )'
    end as signature
from
    ima_dbms_operators a,
    ima_dbms_fis b
where
    a.opid = b.opid
group by a.name, 2
order by a.name
[edit]

Setup

In order to issue the above SQL the following tables need to be registered in 'imadb as $ingres: 

drop ima_dbms_operators;
\p\g
register table ima_dbms_operators (
	server varchar(64) not null not default is
		'SERVER',
	name varchar(30) not null not default is
		'exp.adf.adg.op_name',
	opid integer4 not null not default is /* order within the constructed operator list */
		'exp.adf.adg.op_id',
	type varchar(20) not null not default is /* type of operator */
		'exp.adf.adg.op_type',
        use varchar(30) not null not default is /* where in an expression the operator is used */
                'exp.adf.adg.op_use',
        qlang integer not null not default is /* the query language where the operator is permitted 1=QUEL, 2=SQL*/
                'exp.adf.adg.op_qlangs',
        cntfi integer not null not default is /* count of function instances */
                'exp.adf.adg.op_cntfi'
)
as import from 'tables'
with dbms = IMA,
structure = sortkeyed,
key = (server);
\p\g
grant all on ima_dbms_operators to ingres with grant option;
\p\g
grant select on ima_dbms_operators to public;
\p\g
drop ima_dbms_fis;
\p\g

register table ima_dbms_fis (
        server varchar(64) not null not default is
                'SERVER',
        id integer4 not null not default is
                'exp.adf.adg.fi_id',
        complement integer4 not null not default is
                'exp.adf.adg.fi_cmplmnt',
        type varchar(20) not null not default is
                'exp.adf.adg.fi_type',
        flags integer4 not null not default is
                'exp.adf.adg.fi_flags',
        opid integer4 not null not default is
                'exp.adf.adg.fi_opid',
        args integer4 not null not default is
                'exp.adf.adg.fi_numargs',
        dtresult integer4 not null not default is
                'exp.adf.adg.fi_dtresult',
        dtarg1 integer4 not null not default is
                'exp.adf.adg.fi_dtarg1',
        dtarg2 integer4 not null not default is
                'exp.adf.adg.fi_dtarg2',
        dtarg3 integer4 not null not default is
                'exp.adf.adg.fi_dtarg3',
        dtarg4 integer4 not null not default is
                'exp.adf.adg.fi_dtarg4'
)
as import from 'tables'
with dbms = IMA,
structure = sortkeyed,
key = (server);
\p\g
grant all on ima_dbms_fis to ingres;
\p\g
grant select on ima_dbms_fis to public;
\p\g
[edit]

Ingres 9.2.0

Function name Function signature
+ decimal = ( decimal + )
+ float = ( float + )
+ ingresdate = ( ingresdate + )
+ integer = ( integer + )
+ money = ( money + )
- decimal = ( decimal - )
- float = ( float - )
- ingresdate = ( ingresdate - )
- integer = ( integer - )
- money = ( money - )
* decimal = ( decimal * decimal )
* decimal = ( decimal * integer )
* decimal = ( integer * decimal )
* float = ( decimal * float )
* float = ( float * decimal )
* float = ( float * float )
* float = ( float * integer )
* float = ( integer * float )
* ingresdate = ( float * ingresdate )
* ingresdate = ( ingresdate * float )
* integer = ( integer * integer )
* money = ( decimal * money )
* money = ( float * money )
* money = ( integer * money )
* money = ( money * decimal )
* money = ( money * float )
* money = ( money * integer )
* money = ( money * money )
** float = ( float ** float )
** float = ( float ** integer )
+ byte = ( byte + byte )
+ byte = ( byte + byte varying )
+ byte = ( byte varying + byte )
+ byte varying = ( byte varying + byte varying )
+ c = ( c + c )
+ c = ( c + char )
+ c = ( c + varchar )
+ c = ( char + c )
+ c = ( text + c )
+ c = ( varchar + c )
+ char = ( char + char )
+ char = ( char + varchar )
+ char = ( varchar + char )
+ decimal = ( decimal + decimal )
+ float = ( float + float )
+ ingresdate = ( ingresdate + ingresdate )
+ ingresdate = ( ingresdate + interval day to second )
+ ingresdate = ( ingresdate + interval year to month )
+ ingresdate = ( interval day to second + ingresdate )
+ ingresdate = ( interval year to month + ingresdate )
+ integer = ( integer + integer )
+ long byte = ( long byte + long byte )
+ long varchar = ( long varchar + long varchar )
+ money = ( money + money )
+ nchar = ( nchar + nchar )
+ nvarchar = ( nvarchar + nvarchar )
+ text = ( text + char )
+ text = ( text + text )
+ text = ( text + varchar )
+ text = ( varchar + text )
+ varchar = ( varchar + varchar )
- decimal = ( decimal - decimal )
- float = ( float - float )
- ingresdate = ( ingresdate - ingresdate )
- integer = ( integer - integer )
- interval day to second = ( ansidate - ansidate )
- interval day to second = ( time with local time zone - time with local time zone )
- interval day to second = ( time with time zone - time with time zone )
- interval day to second = ( time without time zone - time without time zone )
- interval day to second = ( timestamp with local time zone - timestamp with local time zone )
- interval day to second = ( timestamp with time zone - timestamp with time zone )
- interval day to second = ( timestamp without time zone - timestamp without time zone )
- money = ( money - money )
/ decimal = ( decimal / decimal )
/ decimal = ( decimal / integer )
/ decimal = ( integer / decimal )
/ float = ( decimal / float )
/ float = ( decimal / money )
/ float = ( float / decimal )
/ float = ( float / float )
/ float = ( float / integer )
/ float = ( float / money )
/ float = ( ingresdate / ingresdate )
/ float = ( integer / float )
/ float = ( integer / money )
/ ingresdate = ( ingresdate / float )
/ integer = ( integer / integer )
/ money = ( money / decimal )
/ money = ( money / float )
/ money = ( money / integer )
/ money = ( money / money )
< = ( < )
< = ( byte < byte )
< = ( byte varying < byte varying )
< = ( c < c )
< = ( char < char )
< = ( decimal < decimal )
< = ( float < float )
< = ( float < integer )
< = ( ingresdate < ingresdate )
< = ( integer < float )
< = ( integer < integer )
< = ( money < money )
< = ( nchar < nchar )
< = ( nvarchar < nvarchar )
< = ( object_key < object_key )
< = ( table_key < table_key )
< = ( text < text )
< = ( varchar < varchar )
<= = ( <= )
<= = ( byte <= byte )
<= = ( byte varying <= byte varying )
<= = ( c <= c )
<= = ( char <= char )
<= = ( decimal <= decimal )
<= = ( float <= float )
<= = ( float <= integer )
<= = ( ingresdate <= ingresdate )
<= = ( integer <= float )
<= = ( integer <= integer )
<= = ( money <= money )
<= = ( nchar <= nchar )
<= = ( nvarchar <= nvarchar )
<= = ( object_key <= object_key )
<= = ( table_key <= table_key )
<= = ( text <= text )
<= = ( varchar <= varchar )
= = ( = )
= = ( byte = byte )
= = ( byte varying = byte varying )
= = ( char = char )
= = ( decimal = decimal )
= = ( float = float )
= = ( float = integer )
= = ( ingresdate = ingresdate )
= = ( integer = float )
= = ( integer = integer )
= = ( money = money )
= = ( nchar = nchar )
= = ( nvarchar = nvarchar )
= = ( object_key = object_key )
= = ( table_key = table_key )
= = ( text = text )
= = ( varchar = varchar )
> = ( > )
> = ( byte > byte )
> = ( byte varying > byte varying )
> = ( c > c )
> = ( char > char )
> = ( decimal > decimal )
> = ( float > float )
> = ( float > integer )
> = ( ingresdate > ingresdate )
> = ( integer > float )
> = ( integer > integer )
> = ( money > money )
> = ( nchar > nchar )
> = ( nvarchar > nvarchar )
> = ( object_key > object_key )
> = ( table_key > table_key )
> = ( text > text )
> = ( varchar > varchar )
>= = ( >= )
>= = ( byte >= byte )
>= = ( byte varying >= byte varying )
>= = ( c >= c )
>= = ( char >= char )
>= = ( decimal >= decimal )
>= = ( float >= float )
>= = ( float >= integer )
>= = ( ingresdate >= ingresdate )
>= = ( integer >= float )
>= = ( integer >= integer )
>= = ( money >= money )
>= = ( nchar >= nchar )
>= = ( nvarchar >= nvarchar )
>= = ( object_key >= object_key )
>= = ( table_key >= table_key )
>= = ( text >= text )
>= = ( varchar >= varchar )
_bintim integer = _bintim( )
_bintim integer = _bintim( integer )
_bio_cnt integer = _bio_cnt( )
_cache_read integer = _cache_read( )
_cache_req integer = _cache_req( )
_cache_rread integer = _cache_rread( )
_cache_size integer = _cache_size( )
_cache_used integer = _cache_used( )
_cache_write integer = _cache_write( )
_cpu_ms integer = _cpu_ms( )
_date c = _date( integer )
_date4 c = _date4( integer )
_dba c = _dba( )
_dio_cnt integer = _dio_cnt( )
_et_sec integer = _et_sec( )
_pfault_cnt integer = _pfault_cnt( )
_phys_page integer = _phys_page( )
_time c = _time( integer )
_usercode c = _usercode( )
_username c = _username( )
_version c = _version( )
_ws_page integer = _ws_page( )
abs decimal = abs( decimal )
abs float = abs( float )
abs integer = abs( integer )
abs money = abs( money )
acos float = acos( float )
ansidate ansidate = ansidate( )
any integer = any( )
any integer = any( char )
any integer = any( decimal )
any integer = any( float )
any integer = any( ingresdate )
any integer = any( integer )
any integer = any( money )
any integer = any( nchar )
any integer = any( nvarchar )
any integer = any( object_key )
any integer = any( table_key )
any integer = any( text )
any integer = any( varchar )
ascii c = ascii( )
ascii c = ascii( , integer )
ascii c = ascii( nchar )
ascii c = ascii( nvarchar )
asin float = asin( float )
atan float = atan( float )
atan2 float = atan2( float, float )
atrim nvarchar = atrim( nchar, char )
atrim nvarchar = atrim( nvarchar, char )
atrim text = atrim( c, char )
atrim text = atrim( text, char )
atrim varchar = atrim( char, char )
atrim varchar = atrim( varchar, char )
avg decimal = avg( decimal )
avg float = avg( float )
avg float = avg( integer )
avg ingresdate = avg( ingresdate )
avg money = avg( money )
avgu decimal = avgu( decimal )
avgu float = avgu( float )
avgu float = avgu( integer )
avgu ingresdate = avgu( ingresdate )
avgu money = avgu( money )
bigint integer = bigint( c )
bigint integer = bigint( char )
bigint integer = bigint( decimal )
bigint integer = bigint( float )
bigint integer = bigint( integer )
bigint integer = bigint( money )
bigint integer = bigint( nchar )
bigint integer = bigint( nvarchar )
bigint integer = bigint( text )
bigint integer = bigint( varchar )
binary byte = binary( )
binary byte = binary( byte )
binary byte = binary( byte varying )
binary byte = binary( byte varying, integer )
binary byte = binary( byte, integer )
binary byte = binary( char )
binary byte = binary( char, integer )
binary byte = binary( varchar )
binary byte = binary( varchar, integer )
bit = bit( )
bit = bit( char )
bit = bit( varchar )
bit_add byte = bit_add( byte, byte )
bit_and byte = bit_and( byte, byte )
bit_length integer = bit_length( )
bit_length integer = bit_length( byte )
bit_length integer = bit_length( byte varying )
bit_length integer = bit_length( char )
bit_length integer = bit_length( long byte )
bit_length integer = bit_length( long varchar )
bit_length integer = bit_length( nchar )
bit_length integer = bit_length( nvarchar )
bit_length integer = bit_length( text )
bit_length integer = bit_length( varchar )
bit_not byte = bit_not( byte )
bit_or byte = bit_or( byte, byte )
bit_xor byte = bit_xor( byte, byte )
byte byte = byte( )
byte byte = byte( byte )
byte byte = byte( byte varying )
byte byte = byte( byte varying, integer )
byte byte = byte( byte, integer )
byte byte = byte( char )
byte byte = byte( char, integer )
byte byte = byte( varchar )
byte byte = byte( varchar, integer )
byteextract char = byteextract( c, integer )
byteextract char = byteextract( char, integer )
byteextract char = byteextract( text, integer )
byteextract char = byteextract( varchar, integer )
c c = c( )
c c = c( , integer )
c c = c( nchar )
c c = c( nvarchar )
ceil decimal = ceil( decimal )
ceiling decimal = ceiling( decimal )
char char = char( )
char char = char( , integer )
char char = char( nchar )
char char = char( nvarchar )
character_length integer = character_length( byte )
character_length integer = character_length( byte varying )
character_length integer = character_length( c )
character_length integer = character_length( char )
character_length integer = character_length( long byte )
character_length integer = character_length( long varchar )
character_length integer = character_length( nchar )
character_length integer = character_length( nvarchar )
character_length integer = character_length( text )
character_length integer = character_length( varchar )
charextract nchar = charextract( nchar, integer )
charextract nchar = charextract( nvarchar, integer )
charextract varchar = charextract( c, integer )
charextract varchar = charextract( char, integer )
charextract varchar = charextract( text, integer )
charextract varchar = charextract( varchar, integer )
chr char = chr( integer )
collation_weight byte varying = collation_weight( c )
collation_weight byte varying = collation_weight( char )
collation_weight byte varying = collation_weight( nchar )
collation_weight byte varying = collation_weight( nchar, integer )
collation_weight byte varying = collation_weight( nvarchar )
collation_weight byte varying = collation_weight( nvarchar, integer )
collation_weight byte varying = collation_weight( text )
collation_weight byte varying = collation_weight( varchar )
concat byte = concat( byte varying, byte )
concat byte = concat( byte, byte )
concat byte = concat( byte, byte varying )
concat byte varying = concat( byte varying, byte varying )
concat c = concat( c, c )
concat c = concat( text, c )
concat c = concat( varchar, c )
concat char = concat( char, char )
concat char = concat( char, varchar )
concat char = concat( varchar, char )
concat long byte = concat( long byte, long byte )
concat long varchar = concat( long varchar, long varchar )
concat nchar = concat( nchar, nchar )
concat nvarchar = concat( nvarchar, nvarchar )
concat text = concat( text, char )
concat text = concat( text, text )
concat text = concat( text, varchar )
concat text = concat( varchar, text )
concat varchar = concat( varchar, varchar )
corr float = corr( float, float )
cos float = cos( float )
count integer = count( )
count integer = count( char )
count integer = count( decimal )
count integer = count( float )
count integer = count( ingresdate )
count integer = count( integer )
count integer = count( money )
count integer = count( object_key )
count integer = count( table_key )
count integer = count( text )
count integer = count( varchar )
count(*)
countu integer = countu( )
countu integer = countu( char )
countu integer = countu( decimal )
countu integer = countu( float )
countu integer = countu( ingresdate )
countu integer = countu( integer )
countu integer = countu( money )
countu integer = countu( object_key )
countu integer = countu( table_key )
countu integer = countu( text )
countu integer = countu( varchar )
covar_pop float = covar_pop( float, float )
covar_samp float = covar_samp( float, float )
current_date ansidate = current_date( )
current_time time with time zone = current_time( )
current_timestamp timestamp with time zone = current_timestamp( )
current_user c = current_user( )
date ingresdate = date( c )
date ingresdate = date( char )
date ingresdate = date( ingresdate )
date ingresdate = date( nchar )
date ingresdate = date( nvarchar )
date ingresdate = date( text )
date ingresdate = date( varchar )
date_gmt char = date_gmt( ingresdate )
date_part integer = date_part( c, ingresdate )
date_part integer = date_part( char, ingresdate )
date_part integer = date_part( text, ingresdate )
date_part integer = date_part( varchar, ingresdate )
date_trunc ingresdate = date_trunc( c, ingresdate )
date_trunc ingresdate = date_trunc( char, ingresdate )
date_trunc ingresdate = date_trunc( text, ingresdate )
date_trunc ingresdate = date_trunc( varchar, ingresdate )
day integer = day( ingresdate )
dba c = dba( )
dbmsinfo varchar = dbmsinfo( varchar )
dec decimal = dec( c, integer )
dec decimal = dec( char, integer )
dec decimal = dec( decimal, integer )
dec decimal = dec( float, integer )
dec decimal = dec( integer, integer )
dec decimal = dec( money, integer )
dec decimal = dec( nchar, integer )
dec decimal = dec( nvarchar, integer )
dec decimal = dec( text, integer )
dec decimal = dec( varchar, integer )
decimal decimal = decimal( c, integer )
decimal decimal = decimal( char, integer )
decimal decimal = decimal( decimal, integer )
decimal decimal = decimal( float, integer )
decimal decimal = decimal( integer, integer )
decimal decimal = decimal( money, integer )
decimal decimal = decimal( nchar, integer )
decimal decimal = decimal( nvarchar, integer )
decimal decimal = decimal( text, integer )
decimal decimal = decimal( varchar, integer )
dow c = dow( ingresdate )
exp float = exp( float )
extract integer = extract( c, ingresdate )
extract integer = extract( char, ingresdate )
extract integer = extract( text, ingresdate )
extract integer = extract( varchar, ingresdate )
float4 float = float4( c )
float4 float = float4( char )
float4 float = float4( decimal )
float4 float = float4( float )
float4 float = float4( integer )
float4 float = float4( money )
float4 float = float4( nchar )
float4 float = float4( nvarchar )
float4 float = float4( text )
float4 float = float4( varchar )
float8 float = float8( c )
float8 float = float8( char )
float8 float = float8( decimal )
float8 float = float8( float )
float8 float = float8( integer )
float8 float = float8( money )
float8 float = float8( nchar )
float8 float = float8( nvarchar )
float8 float = float8( text )
float8 float = float8( varchar )
floor decimal = floor( decimal )
gmt_timestamp char = gmt_timestamp( integer )
hash integer = hash( )
hex varchar = hex( )
hex varchar = hex( char )
hex varchar = hex( text )
hex varchar = hex( varchar )
hour integer = hour( ingresdate )
ifnull c = ifnull( c, c )
ifnull char = ifnull( char, char )
ifnull decimal = ifnull( decimal, decimal )
ifnull float = ifnull( float, float )
ifnull ingresdate = ifnull( ingresdate, ingresdate )
ifnull integer = ifnull( integer, integer )
ifnull money = ifnull( money, money )
ifnull nchar = ifnull( nchar, nchar )
ifnull nvarchar = ifnull( nvarchar, nvarchar )
ifnull text = ifnull( text, text )
ifnull varchar = ifnull( varchar, varchar )
ii_cpn_dump varchar = ii_cpn_dump( long varchar )
ii_di_tabid integer = ii_di_tabid( char )
ii_dv_desc varchar = ii_dv_desc( )
ii_ext_length integer = ii_ext_length( integer, integer )
ii_ext_type integer = ii_ext_type( integer, integer )
ii_iftrue = ii_iftrue( integer, )
ii_ipaddr byte = ii_ipaddr( c )
ii_ipaddr byte = ii_ipaddr( char )
ii_ipaddr byte = ii_ipaddr( text )
ii_ipaddr byte = ii_ipaddr( varchar )
ii_ipaddr byte varying = ii_ipaddr( c )
ii_ipaddr byte varying = ii_ipaddr( char )
ii_ipaddr byte varying = ii_ipaddr( text )
ii_ipaddr byte varying = ii_ipaddr( varchar )
ii_lolk table_key = ii_lolk( )
ii_lolk table_key = ii_lolk( long byte )
ii_notrm_txt text = ii_notrm_txt( char )
ii_notrm_vch varchar = ii_notrm_vch( char )
ii_row_count integer = ii_row_count( integer, integer )
ii_tabid_di char = ii_tabid_di( integer, integer )
iichar12 char = iichar12( c )
iichar12 char = iichar12( char )
iichar12 char = iichar12( text )
iichar12 char = iichar12( varchar )
iihexint integer = iihexint( text )
iihexint integer = iihexint( varchar )
iipermittype char = iipermittype( integer, integer )
iistructure char = iistructure( integer )
iitableinfo varchar = iitableinfo( varchar, integer, integer )
iitblstat integer = iitblstat( integer )
iitotal_allocated_pages integer = iitotal_allocated_pages( integer, integer )
iitotal_overflow_pages integer = iitotal_overflow_pages( integer, integer )
iitypename char = iitypename( integer )
iiuserlen integer = iiuserlen( integer, integer )
iiutf16_to_utf8 varchar = iiutf16_to_utf8( nchar )
iiutf16_to_utf8 varchar = iiutf16_to_utf8( nvarchar )
iiutf8_to_utf16 nchar = iiutf8_to_utf16( varchar )
iiutf8_to_utf16 nvarchar = iiutf8_to_utf16( varchar )
ingresdate ingresdate = ingresdate( c )
ingresdate ingresdate = ingresdate( char )
ingresdate ingresdate = ingresdate( ingresdate )
ingresdate ingresdate = ingresdate( nchar )
ingresdate ingresdate = ingresdate( nvarchar )
ingresdate ingresdate = ingresdate( text )
ingresdate ingresdate = ingresdate( varchar )
initial_user char = initial_user( )
int integer = int( c )
int integer = int( char )
int integer = int( decimal )
int integer = int( float )
int integer = int( integer )
int integer = int( money )
int integer = int( nchar )
int integer = int( nvarchar )
int integer = int( text )
int integer = int( varchar )
int1 integer = int1( c )
int1 integer = int1( char )
int1 integer = int1( decimal )
int1 integer = int1( float )
int1 integer = int1( integer )
int1 integer = int1( money )
int1 integer = int1( nchar )
int1 integer = int1( nvarchar )
int1 integer = int1( text )
int1 integer = int1( varchar )
int2 integer = int2( c )
int2 integer = int2( char )
int2 integer = int2( decimal )
int2 integer = int2( float )
int2 integer = int2( integer )
int2 integer = int2( money )
int2 integer = int2( nchar )
int2 integer = int2( nvarchar )
int2 integer = int2( text )
int2 integer = int2( varchar )
int4 integer = int4( c )
int4 integer = int4( char )
int4 integer = int4( decimal )
int4 integer = int4( float )
int4 integer = int4( integer )
int4 integer = int4( money )
int4 integer = int4( nchar )
int4 integer = int4( nvarchar )
int4 integer = int4( text )
int4 integer = int4( varchar )
int8 integer = int8( c )
int8 integer = int8( char )
int8 integer = int8( decimal )
int8 integer = int8( float )
int8 integer = int8( integer )
int8 integer = int8( money )
int8 integer = int8( nchar )
int8 integer = int8( nvarchar )
int8 integer = int8( text )
int8 integer = int8( varchar )
integer integer = integer( c )
integer integer = integer( char )
integer integer = integer( decimal )
integer integer = integer( float )
integer integer = integer( integer )
integer integer = integer( money )
integer integer = integer( nchar )
integer integer = integer( nvarchar )
integer integer = integer( text )
integer integer = integer( varchar )
interval float = interval( c, ingresdate )
interval float = interval( char, ingresdate )
interval float = interval( text, ingresdate )
interval float = interval( varchar, ingresdate )
interval_dtos interval day to second = interval_dtos( )
interval_ytom interval year to month = interval_ytom( )
intextract integer = intextract( byte varying, integer )
intextract integer = intextract( byte, integer )
is decimal = ( is decimal )
is float = ( is float )
is integer = ( is integer )
is not decimal = ( is not decimal )
is not float = ( is not float )
is not integer = ( is not integer )
is not null = ( is not null )
is not null = ( c is not null )
is not null = ( char is not null )
is not null = ( float is not null )
is not null = ( ingresdate is not null )
is not null = ( integer is not null )
is not null = ( money is not null )
is not null = ( nchar is not null )
is not null = ( nvarchar is not null )
is not null = ( object_key is not null )
is not null = ( table_key is not null )
is not null = ( text is not null )
is not null = ( varchar is not null )
is null = ( is null )
is null = ( c is null )
is null = ( char is null )
is null = ( float is null )
is null = ( ingresdate is null )
is null = ( integer is null )
is null = ( money is null )
is null = ( nchar is null )
is null = ( nvarchar is null )
is null = ( object_key is null )
is null = ( table_key is null )
is null = ( text is null )
is null = ( varchar is null )
isdst integer = isdst( ingresdate )
left byte = left( byte, integer )
left byte varying = left( byte varying, integer )
left c = left( c, integer )
left char = left( char, integer )
left long byte = left( long byte, integer )
left long varchar = left( long varchar, integer )
left nchar = left( nchar, integer )
left nvarchar = left( nvarchar, integer )
left text = left( text, integer )
left varchar = left( varchar, integer )
length integer = length( )
length integer = length( byte )
length integer = length( byte varying )
length integer = length( c )
length integer = length( char )
length integer = length( long byte )
length integer = length( long nvarchar )
length integer = length( long varchar )
length integer = length( nchar )
length integer = length( nvarchar )
length integer = length( text )
length integer = length( varchar )
like = ( c like c )
like = ( char like char )
like = ( nvarchar like nvarchar )
like = ( text like text )
like = ( varchar like varchar )
ln float = ln( float )
local_time time with local time zone = local_time( )
local_timestamp timestamp with local time zone = local_timestamp( )
locate integer = locate( nvarchar, nvarchar )
locate integer = locate( varchar, varchar )
log float = log( float )
long_binary long byte = long_binary( )
long_binary long byte = long_binary( byte )
long_binary long byte = long_binary( byte varying )
long_binary long byte = long_binary( c )
long_binary long byte = long_binary( char )
long_binary long byte = long_binary( long byte )
long_binary long byte = long_binary( long varchar )
long_binary long byte = long_binary( nchar )
long_binary long byte = long_binary( nvarchar )
long_binary long byte = long_binary( text )
long_binary long byte = long_binary( varchar )
long_byte long byte = long_byte( )
long_byte long byte = long_byte( byte )
long_byte long byte = long_byte( byte varying )
long_byte long byte = long_byte( c )
long_byte long byte = long_byte( char )
long_byte long byte = long_byte( long byte )
long_byte long byte = long_byte( long varchar )
long_byte long byte = long_byte( nchar )
long_byte long byte = long_byte( nvarchar )
long_byte long byte = long_byte( text )
long_byte long byte = long_byte( varchar )
long_varchar long varchar = long_varchar( )
long_varchar long varchar = long_varchar( c )
long_varchar long varchar = long_varchar( char )
long_varchar long varchar = long_varchar( long byte )
long_varchar long varchar = long_varchar( long varchar )
long_varchar long varchar = long_varchar( text )
long_varchar long varchar = long_varchar( varchar )
lower c = lower( c )
lower char = lower( char )
lower long nvarchar = lower( long nvarchar )
lower long varchar = lower( long varchar )
lower nchar = lower( nchar )
lower nvarchar = lower( nvarchar )
lower text = lower( text )
lower varchar = lower( integer )
lower varchar = lower( varchar )
lowercase c = lowercase( c )
lowercase char = lowercase( char )
lowercase long nvarchar = lowercase( long nvarchar )
lowercase long varchar = lowercase( long varchar )
lowercase nchar = lowercase( nchar )
lowercase nvarchar = lowercase( nvarchar )
lowercase text = lowercase( text )
lowercase varchar = lowercase( integer )
lowercase varchar = lowercase( varchar )
lpad varchar = lpad( char, integer )
lpad varchar = lpad( char, integer, varchar )
lpad varchar = lpad( varchar, integer )
lpad varchar = lpad( varchar, integer, varchar )
ltrim nvarchar = ltrim( nchar )
ltrim nvarchar = ltrim( nvarchar )
ltrim varchar = ltrim( char )
ltrim varchar = ltrim( varchar )
max c = max( c )
max char = max( char )
max decimal = max( decimal )
max float = max( float )
max ingresdate = max( ingresdate )
max integer = max( integer )
max money = max( money )
max nchar = max( nchar )
max nvarchar = max( nvarchar )
max object_key = max( object_key )
max table_key = max( table_key )
max text = max( text )
max varchar = max( varchar )
microsecond integer = microsecond( ingresdate )
min c = min( c )
min char = min( char )
min decimal = min( decimal )
min float = min( float )
min ingresdate = min( ingresdate )
min integer = min( integer )
min money = min( money )
min nchar = min( nchar )
min nvarchar = min( nvarchar )
min object_key = min( object_key )
min table_key = min( table_key )
min text = min( text )
min varchar = min( varchar )
minute integer = minute( ingresdate )
mod integer = mod( integer, integer )
money money = money( c )
money money = money( char )
money money = money( decimal )
money money = money( float )
money money = money( integer )
money money = money( money )
money money = money( nchar )
money money = money( nvarchar )
money money = money( text )
money money = money( varchar )
month integer = month( ingresdate )
nanosecond integer = nanosecond( ingresdate )
nchar nchar = nchar( )
nchar nchar = nchar( , integer )
not like = ( c not like c )
not like = ( char not like char )
not like = ( nvarchar not like nvarchar )
not like = ( text not like text )
not like = ( varchar not like varchar )
numeric decimal = numeric( c, integer )
numeric decimal = numeric( char, integer )
numeric decimal = numeric( decimal, integer )
numeric decimal = numeric( float, integer )
numeric decimal = numeric( integer, integer )
numeric decimal = numeric( money, integer )
numeric decimal = numeric( nchar, integer )
numeric decimal = numeric( nvarchar, integer )
numeric decimal = numeric( text, integer )
numeric decimal = numeric( varchar, integer )
numericnorm byte = numericnorm( )
nvarchar nvarchar = nvarchar( )
nvarchar nvarchar = nvarchar( , integer )
object_key object_key = object_key( char )
object_key object_key = object_key( object_key )
octet_length integer = octet_length( byte )
octet_length integer = octet_length( byte varying )
octet_length integer = octet_length( c )
octet_length integer = octet_length( char )
octet_length integer = octet_length( long byte )
octet_length integer = octet_length( long varchar )
octet_length integer = octet_length( nchar )
octet_length integer = octet_length( nvarchar )
octet_length integer = octet_length( text )
octet_length integer = octet_length( varchar )
pad nvarchar = pad( nchar )
pad nvarchar = pad( nvarchar )
pad text = pad( c )
pad text = pad( text )
pad varchar = pad( char )
pad varchar = pad( varchar )
pi float = pi( )
position integer = position( byte varying, byte varying )
position integer = position( byte varying, byte varying, integer )
position integer = position( byte varying, long byte )
position integer = position( byte varying, long byte, integer )
position integer = position( long byte, long byte )
position integer = position( long byte, long byte, integer )
position integer = position( long nvarchar, long nvarchar )
position integer = position( long nvarchar, long nvarchar, integer )
position integer = position( long varchar, long varchar )
position integer = position( long varchar, long varchar, integer )
position integer = position( nvarchar, long nvarchar )
position integer = position( nvarchar, long nvarchar, integer )
position integer = position( nvarchar, nvarchar )
position integer = position( nvarchar, nvarchar, integer )
position integer = position( varchar, long varchar )
position integer = position( varchar, long varchar, integer )
position integer = position( varchar, varchar )
position integer = position( varchar, varchar, integer )
power float = ( float power float )
power float = ( float power integer )
quarter integer = quarter( ingresdate )
random integer = random( )
random integer = random( integer, integer )
randomf float = randomf( )
randomf float = randomf( float, float )
randomf integer = randomf( integer, integer )
regr_avgx float = regr_avgx( float, float )
regr_avgy float = regr_avgy( float, float )
regr_count integer = regr_count( , )
regr_intercept float = regr_intercept( float, float )
regr_r2 float = regr_r2( float, float )
regr_slope float = regr_slope( float, float )
regr_sxx float = regr_sxx( float, float )
regr_sxy float = regr_sxy( float, float )
regr_syy float = regr_syy( float, float )
replace varchar = replace( char, varchar, varchar )
replace varchar = replace( varchar, varchar, varchar )
resolve_table varchar = resolve_table( text, text )
resolve_table varchar = resolve_table( varchar, varchar )
right byte = right( byte, integer )
right byte varying = right( byte varying, integer )
right c = right( c, integer )
right char = right( char, integer )
right long byte = right( long byte, integer )
right long varchar = right( long varchar, integer )
right nchar = right( nchar, integer )
right nvarchar = right( nvarchar, integer )
right text = right( text, integer )
right varchar = right( varchar, integer )
round decimal = round( decimal, integer )
rpad varchar = rpad( char, integer )
rpad varchar = rpad( char, integer, varchar )
rpad varchar = rpad( varchar, integer )
rpad varchar = rpad( varchar, integer, varchar )
rtrim nvarchar = rtrim( nchar )
rtrim nvarchar = rtrim( nvarchar )
rtrim text = rtrim( c )
rtrim text = rtrim( text )
rtrim varchar = rtrim( char )
rtrim varchar = rtrim( varchar )
second integer = second( ingresdate )
session_priv char = session_priv( )
session_user char = session_user( )
shift byte = shift( byte, integer )
shift byte varying = shift( byte varying, integer )
shift c = shift( c, integer )
shift char = shift( char, integer )
shift long byte = shift( long byte, integer )
shift nchar = shift( nchar, integer )
shift nvarchar = shift( nvarchar, integer )
shift text = shift( text, integer )
shift varchar = shift( varchar, integer )
sign integer = sign( decimal )
sign integer = sign( float )
sign integer = sign( integer )
sin float = sin( float )
size integer = size( )
size integer = size( byte )
size integer = size( byte varying )
size integer = size( c )
size integer = size( char )
size integer = size( long byte )
size integer = size( long nvarchar )
size integer = size( long varchar )
size integer = size( nchar )
size integer = size( nvarchar )
size integer = size( text )
size integer = size( varchar )
smallint integer = smallint( c )
smallint integer = smallint( char )
smallint integer = smallint( decimal )
smallint integer = smallint( float )
smallint integer = smallint( integer )
smallint integer = smallint( money )
smallint integer = smallint( nchar )
smallint integer = smallint( nvarchar )
smallint integer = smallint( text )
smallint integer = smallint( varchar )
soundex char = soundex( byte )
soundex char = soundex( byte varying )
soundex char = soundex( c )
soundex char = soundex( char )
soundex char = soundex( text )
soundex char = soundex( varchar )
sqrt float = sqrt( float )
squeeze nvarchar = squeeze( nchar )
squeeze nvarchar = squeeze( nvarchar )
squeeze text = squeeze( c )
squeeze text = squeeze( text )
squeeze varchar = squeeze( char )
squeeze varchar = squeeze( varchar )
stddev_pop float = stddev_pop( float )
stddev_samp float = stddev_samp( float )
substr long byte = substr( long byte, integer )
substr long byte = substr( long byte, integer, integer )
substr long nvarchar = substr( long nvarchar, integer )
substr long nvarchar = substr( long nvarchar, integer, integer )
substr long varchar = substr( long varchar, integer )
substr long varchar = substr( long varchar, integer, integer )
substr nvarchar = substr( nchar, integer )
substr nvarchar = substr( nchar, integer, integer )
substr nvarchar = substr( nvarchar, integer )
substr nvarchar = substr( nvarchar, integer, integer )
substr varchar = substr( c, integer )
substr varchar = substr( c, integer, integer )
substr varchar = substr( char, integer )
substr varchar = substr( char, integer, integer )
substr varchar = substr( text, integer )
substr varchar = substr( text, integer, integer )
substr varchar = substr( varchar, integer )
substr varchar = substr( varchar, integer, integer )
substring long byte = substring( long byte, integer )
substring long byte = substring( long byte, integer, integer )
substring long nvarchar = substring( long nvarchar, integer )
substring long nvarchar = substring( long nvarchar, integer, integer )
substring long varchar = substring( long varchar, integer )
substring long varchar = substring( long varchar, integer, integer )
substring nvarchar = substring( nchar, integer )
substring nvarchar = substring( nchar, integer, integer )
substring nvarchar = substring( nvarchar, integer )
substring nvarchar = substring( nvarchar, integer, integer )
substring varchar = substring( c, integer )
substring varchar = substring( c, integer, integer )
substring varchar = substring( char, integer )
substring varchar = substring( char, integer, integer )
substring varchar = substring( text, integer )
substring varchar = substring( text, integer, integer )
substring varchar = substring( varchar, integer )
substring varchar = substring( varchar, integer, integer )
sum decimal = sum( decimal )
sum float = sum( float )
sum ingresdate = sum( ingresdate )
sum integer = sum( integer )
sum money = sum( money )
sumu decimal = sumu( decimal )
sumu float = sumu( float )
sumu ingresdate = sumu( ingresdate )
sumu integer = sumu( integer )
sumu money = sumu( money )
system_user char = system_user( )
table_key table_key = table_key( char )
table_key table_key = table_key( table_key )
tan float = tan( float )
text text = text( )
text text = text( , integer )
text text = text( nchar )
text text = text( nvarchar )
time time without time zone = time( )
time_local time with local time zone = time_local( )
time_with_tz time with time zone = time_with_tz( )
time_wo_tz time without time zone = time_wo_tz( )
timestamp timestamp without time zone = timestamp( )
timestamp_local timestamp with local time zone = timestamp_local( )
timestamp_with_tz timestamp with time zone = timestamp_with_tz( )
timestamp_wo_tz timestamp without time zone = timestamp_wo_tz( )
tinyint integer = tinyint( c )
tinyint integer = tinyint( char )
tinyint integer = tinyint( decimal )
tinyint integer = tinyint( float )
tinyint integer = tinyint( integer )
tinyint integer = tinyint( money )
tinyint integer = tinyint( nchar )
tinyint integer = tinyint( nvarchar )
tinyint integer = tinyint( text )
tinyint integer = tinyint( varchar )
trim nvarchar = trim( nchar )
trim nvarchar = trim( nvarchar )
trim text = trim( c )
trim text = trim( text )
trim varchar = trim( char )
trim varchar = trim( varchar )
trunc decimal = trunc( decimal, integer )
truncate decimal = truncate( decimal, integer )
unhex byte varying = unhex( c )
unhex byte varying = unhex( char )
unhex byte varying = unhex( text )
unhex byte varying = unhex( varchar )
unorm nvarchar = unorm( nvarchar )
unorm varchar = unorm( varchar )
upper c = upper( c )
upper char = upper( char )
upper long nvarchar = upper( long nvarchar )
upper long varchar = upper( long varchar )
upper nchar = upper( nchar )
upper nvarchar = upper( nvarchar )
upper text = upper( text )
upper varchar = upper( integer )
upper varchar = upper( varchar )
uppercase c = uppercase( c )
uppercase char = uppercase( char )
uppercase long nvarchar = uppercase( long nvarchar )
uppercase long varchar = uppercase( long varchar )
uppercase nchar = uppercase( nchar )
uppercase nvarchar = uppercase( nvarchar )
uppercase text = uppercase( text )
uppercase varchar = uppercase( integer )
uppercase varchar = uppercase( varchar )
user c = user( )
usercode c = usercode( )
username c = username( )
uuid_compare integer = uuid_compare( byte, byte )
uuid_create byte = uuid_create( )
uuid_from_char byte = uuid_from_char( c )
uuid_from_char byte = uuid_from_char( char )
uuid_from_char byte = uuid_from_char( text )
uuid_from_char byte = uuid_from_char( varchar )
uuid_to_char char = uuid_to_char( byte )
var_pop float = var_pop( float )
var_samp float = var_samp( float )
varbinary byte varying = varbinary( )
varbinary byte varying = varbinary( , integer )
varbinary byte varying = varbinary( byte )
varbinary byte varying = varbinary( byte varying )
varbinary byte varying = varbinary( byte varying, integer )
varbinary byte varying = varbinary( byte, integer )
varbinary byte varying = varbinary( char )
varbinary byte varying = varbinary( char, integer )
varbinary byte varying = varbinary( varchar )
varbinary byte varying = varbinary( varchar, integer )
varbit = varbit( )
varbit = varbit( char )
varbit = varbit( varchar )
varbyte byte varying = varbyte( )
varbyte byte varying = varbyte( , integer )
varbyte byte varying = varbyte( byte )
varbyte byte varying = varbyte( byte varying )
varbyte byte varying = varbyte( byte varying, integer )
varbyte byte varying = varbyte( byte, integer )
varbyte byte varying = varbyte( char )
varbyte byte varying = varbyte( char, integer )
varbyte byte varying = varbyte( varchar )
varbyte byte varying = varbyte( varchar, integer )
varchar varchar = varchar( )
varchar varchar = varchar( , integer )
varchar varchar = varchar( nchar )
varchar varchar = varchar( nvarchar )
vchar text = vchar( )
vchar text = vchar( , integer )
vchar text = vchar( nchar )
vchar text = vchar( nvarchar )
week integer = week( ingresdate )
week_iso integer = week_iso( ingresdate )
xyzzy varchar = xyzzy( )
year integer = year( ingresdate )
[edit]

Ingres 9.3.0

Additions since 9.2.0

Function name Function signature
long_nvarchar long nvarchar = long_nvarchar( )
long_nvarchar long nvarchar = long_nvarchar( c )
long_nvarchar long nvarchar = long_nvarchar( char )
long_nvarchar long nvarchar = long_nvarchar( long byte )
long_nvarchar long nvarchar = long_nvarchar( long nvarchar )
long_nvarchar long nvarchar = long_nvarchar( long varchar )
long_nvarchar long nvarchar = long_nvarchar( text )
long_nvarchar long nvarchar = long_nvarchar( varchar )
patcomp = patcomp( char )
patcomp = patcomp( nvarchar )
patcomp = patcomp( varchar )
[edit]

Ingres 10.0.0

Additions since 9.3.0

Note - This might not represent the actual list of functions available in the latest code as Ingres 10.0 is still under development

  1. REDIRECT Ingres 10.0.0 Function List
Retrieved from "http://community.actian.com/wiki/Ingres_DBMS_function_list"
Personal tools
Actian  |  Download Software  |  Enterprise Support  |  Contact Us  |  Terms of Use  |  Actian Corporation  |  Top
© 2011 Actian Corporation. All Rights Reserved