sqlfunc.hlp
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- .pgaw:Help.f.t insert end
- "SQL functionsnn" {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 functionsn" {link pgfunctions}
- "Next - mathematical functions" {link mathfunc}