Kexi/Plugins/Queries/SQL Functions

This page lists SQL functions that Kexi supports or wants to support. Aggregate functions are included. Support in particular SQL backends is compared (SQLite, PostgreSQL, MySQL). For practical reasons emphasis is put on concrete implementation instead of an SQL standard.

Functions

Name	Description	sqlite	pgsql	mysql	mssql	xbase
{{{name}}}	{{{desc}}}	{{{sqlite}}}	{{{pg}}}	{{{my}}}	{{{ms}}}	{{{xb}}}

Further work

Add comparison for other backends: Sybase/MSSQL, xBase.

Links

• SQLite docs: Core Functions, Date And Time Functions, Aggregate Functions