Kexi/Plugins/Queries/SQL Functions: Difference between revisions

Revision as of 09:06, 11 December 2014

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}}}

Aggregate functions

Further work

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

Links

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

@@ Line 1: / Line 1: @@
+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==
+{{TableStart}}
+! width=5 | Name
+! width=100% | Description
+! width=10 | sqlite
+! width=10 | pgsql
+! width=10 | mysql
+! width=10 | mssql
+! width=10 | xbase
+|- valign=top
+| | {{{name}}}
+| | {{{desc}}}
+| | {{{sqlite}}}
+| | {{{pg}}}
+| | {{{my}}}
+| | {{{ms}}}
+| | {{{xb}}}
+|}
+==Aggregate functions==
+==Further work==
+Add comparison for other backends: Sybase/MSSQL, xBase.
 ==Links==
 *SQLite docs: [https://www.sqlite.org/lang_corefunc.html Core Functions], [https://www.sqlite.org/lang_datefunc.html Date And Time Functions], [https://www.sqlite.org/lang_aggfunc.html Aggregate Functions]