Documentation Source Text

Check-in [93257a1a8d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Typo: iff() should be iif().
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 93257a1a8d0f1a7c959f773df60ee64c371a023f43661271adc60b34df25222c
User & Date: drh 2020-05-23 02:01:17
Context
2020-05-23
02:05
Fix typo in SQLITE_USE_ALLOCA documentation. check-in: 5a6f07e675 user: drh tags: trunk
02:01
Typo: iff() should be iif(). check-in: 93257a1a8d user: drh tags: trunk
2020-05-22
17:48
Version 3.32.0 check-in: d816b04a78 user: drh tags: trunk, release, version-3.32.0
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang_corefunc.in.

55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
  ^The ifnull() function returns a copy of its first non-NULL argument, or
  NULL if both arguments are NULL.  ^Ifnull() must have exactly 2 arguments.
  ^The ifnull() function is equivalent to [coalesce()] with two arguments.
}

funcdef {iif(X,Y,Z)} {} {
  ^The iif(X,Y,Z) function returns the value Y if X is true, and Z otherwise.
  ^The iff(X,Y,Z) function is logically equivalent to and generates the same
  [bytecode] as the [CASE expression] "CASE WHEN X THEN Y ELSE Z END".
}

funcdef {instr(X,Y)} {} {
  ^The instr(X,Y) function finds the first occurrence of string Y within 
  string X and returns the number of prior characters plus 1, or 0 if
  Y is nowhere found within X.







|







55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
  ^The ifnull() function returns a copy of its first non-NULL argument, or
  NULL if both arguments are NULL.  ^Ifnull() must have exactly 2 arguments.
  ^The ifnull() function is equivalent to [coalesce()] with two arguments.
}

funcdef {iif(X,Y,Z)} {} {
  ^The iif(X,Y,Z) function returns the value Y if X is true, and Z otherwise.
  ^The iif(X,Y,Z) function is logically equivalent to and generates the same
  [bytecode] as the [CASE expression] "CASE WHEN X THEN Y ELSE Z END".
}

funcdef {instr(X,Y)} {} {
  ^The instr(X,Y) function finds the first occurrence of string Y within 
  string X and returns the number of prior characters plus 1, or 0 if
  Y is nowhere found within X.