Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
new help texts for operators
  • Loading branch information
astroidex committed Sep 15, 2013
1 parent 6ec9e75 commit 1670a27
Show file tree
Hide file tree
Showing 6 changed files with 84 additions and 0 deletions.
13 changes: 13 additions & 0 deletions resources/function_help/AND
@@ -0,0 +1,13 @@
<h3>AND logical operator</h3>
Returns 1 when condition a and b are true.

<h4>Syntax</h4>
<pre> condition a AND condition b </pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 4 = 2+2 AND 1 = 1 &rarr; returns 1 </pre>
<pre> 4 = 2+2 AND 1 = 2 &rarr; returns 0 </pre>

13 changes: 13 additions & 0 deletions resources/function_help/ILIKE
@@ -0,0 +1,13 @@
<h3>LIKE expression</h3>
Returns 1 if the first parameter matches case-insensitive the supplied pattern. ILIKE can be used instead of LIKE to make the match case-insensitive. Works with numbers also.

<h4>Syntax</h4>
<pre>string/number LIKE pattern</pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 'A' ILIKE 'A' &rarr; returns 1 </pre>
<pre> 'A' ILIKE 'a' &rarr; returns 1 </pre>
<pre> 'A' ILIKE 'B' &rarr; returns 0 </pre>
18 changes: 18 additions & 0 deletions resources/function_help/IS
@@ -0,0 +1,18 @@
<h3>IS expression</h3>
Returns 1 if a is the same as b.

<h4>Syntax</h4>
<pre>a is b</pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 'A' IS 'A' &rarr; returns 1 </pre>
<pre> 'A' IS 'a' &rarr; returns 0 </pre>
<pre> 4 IS 4 &rarr; returns 1 </pre>
<pre> 4 IS 2+2 &rarr; returns 1 </pre>
<pre> 4 IS 2 &rarr; returns 0 </pre>
<pre> 4 IS 2 &rarr; returns 0 </pre>
<pre> $geometry IS NULL &rarr; returns 0, if your geometry is not NULL</pre>

13 changes: 13 additions & 0 deletions resources/function_help/LIKE
@@ -0,0 +1,13 @@
<h3>LIKE expression</h3>
Returns 1 if the first parameter matches the supplied pattern. Works with numbers also.

<h4>Syntax</h4>
<pre>string/number LIKE pattern</pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 'A' LIKE 'A' &rarr; returns 1 </pre>
<pre> 'A' LIKE 'a' &rarr; returns 0 </pre>
<pre> 'A' LIKE 'B' &rarr; returns 0 </pre>
14 changes: 14 additions & 0 deletions resources/function_help/NOT
@@ -0,0 +1,14 @@
<h3>NOT</h3>
Returns 1 if a is not the same as b.

<h4>Syntax</h4>
<pre> a NOT b </pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 'a' IS NOT 'b' &rarr; returns 1 </pre>
<pre> 'a' IS NOT 'a' &rarr; returns 0 </pre>
<pre> 4 IS NOT 2+2 &rarr; returns 0 </pre>

13 changes: 13 additions & 0 deletions resources/function_help/OR
@@ -0,0 +1,13 @@
<h3>OR logical operator</h3>
Returns 1 when condition a or b is true.

<h4>Syntax</h4>
<pre> condition a OR condition b </pre>

<h4>Arguments</h4>
None

<h4>Example</h4>
<pre> 4 = 2+2 OR 1 = 1 &rarr; returns 1 </pre>
<pre> 4 = 2+2 OR 1 = 2 &rarr; returns 1 </pre>
<pre> 4 = 2 OR 1 = 2 &rarr; returns 0 </pre>

0 comments on commit 1670a27

Please sign in to comment.