blob: 5440ec153eae7f2c5a4cb5d54adb924877d44e2d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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}
|
