1 files changed, 21 insertions, 0 deletions
diff --git a/src/bin/pgaccess/lib/help/sqlfunc.hlp b/src/bin/pgaccess/lib/help/sqlfunc.hlp
new file mode 100644
index 00000000000..5440ec153ea
--- /dev/null
+++ b/src/bin/pgaccess/lib/help/sqlfunc.hlp
@@ -0,0 +1,21 @@
+.pgaw:Help.f.t insert end \
+"SQL functions\n\n" {title} \
+"COALESCE(list)" {bold} " 
+	return first non-NULL value in list 
+	Example:
+		COALESCE(a2, c2 + 5, 0)
+
+" {} "IFNULL(input,non-NULL substitute)" {bold} " 
+	return second argument if first is NULL 
+	Example:
+		IFNULL(c1, 'N/A')
+
+" {} "CASE WHEN expr THEN expr \[...\] ELSE expr END" {bold} " 
+	return expression for first true clause 
+	Example:
+		CASE WHEN c1 = 1 THEN 'match' ELSE 'no match' END 
+
+
+" {} \
+"PostgreSQL functions\n" {link pgfunctions} \
+"Next - mathematical functions" {link mathfunc}