7.47. Func About

  • Date Functions

  • Group Functions

  • Numeric Functions

  • String Functions

  • System Functions

7.47.1. Date Functions

Table 7.6. SQL and Generic Functions

Object

Name Description

current_date

The CURRENT_DATE() SQL function

current_time

The CURRENT_TIME() SQL function

current_timestamp

The CURRENT_TIMESTAMP() SQL function

localtime

The localtime() SQL function

localtimestamp

The localtimestamp() SQL function

now

The SQL now() datetime function

7.47.2. Group Functions

Table 7.7. SQL and Generic Functions

Object

Name Description

grouping_sets

Implement the GROUPING SETS grouping operation

next_value

Represent the 'next value', given a Sequence as its single argument

rollup

Implement the ROLLUP grouping operation

7.47.3. Numeric Functions

Table 7.8. SQL and Generic Functions

Object

Name Description

array_agg

Support for the ARRAY_AGG function

count

The ANSI COUNT aggregate function. With no arguments, emits COUNT *

cube

Implement the CUBE grouping operation

cume_dist

Implement the cume_dist hypothetical-set aggregate function

dense_rank

Implement the dense_rank hypothetical-set aggregate function

max

The SQL MAX() aggregate function

min

The SQL MIN() aggregate function

mode

Implement the mode ordered-set aggregate function

percent_rank

Implement the percent_rank hypothetical-set aggregate function

percentile_cont

Implement the percentile_cont ordered-set aggregate function

percentile_disc

Implement the percentile_disc ordered-set aggregate function

random

The RANDOM() SQL function

rank

Implement the rank hypothetical-set aggregate function

sum

The SQL SUM() aggregate function

7.47.4. String Functions

Table 7.9. SQL and Generic Functions

Object

Name Description

char_length

The CHAR_LENGTH() SQL function

coalesce

concat

The SQL CONCAT() function, which concatenates strings

7.47.5. System Functions

Table 7.10. System Functions

Object

Name Description

current_user

The CURRENT_USER() SQL function

session_user

The SESSION_USER() SQL function

sysdate

The SYSDATE() SQL function

user

The USER() SQL function

Table 7.11. Function Operations

Object

Name Description

AnsiFunction

Define a function in 'ansi' format, which doesn't render parenthesis

Function

Describe a named SQL function

FunctionAsBinary

FunctionElement

Base for SQL function-oriented constructs

GenericFunction

Define a 'generic' function

OrderedSetAgg

Define a function where the return type is based on the sort expression type as defined by the expression passed to the FunctionElement.within_group() method

register_function

Associate a callable with a particular func. name

ReturnTypeFromArgs

Define a function whose return type is the same as its arguments

ScalarFunctionColumn

7.47.6. Further Reading