User Tools

Site Tools


podoc:tokenized_ilike_sql_function

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
podoc:tokenized_ilike_sql_function [2007/04/18 11:03]
Luud
podoc:tokenized_ilike_sql_function [2007/04/23 10:32] (current)
Luud
Line 21: Line 21:
 === Schema === === Schema ===
  
-<​code>​+<​code ​sql>
 -- This function is exactly like tokenized_like,​ but it is case insensitive -- This function is exactly like tokenized_like,​ but it is case insensitive
 create function tokenized_ilike(varchar,​ varchar) returns bool as ' create function tokenized_ilike(varchar,​ varchar) returns bool as '
Line 33: Line 33:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- we define operators for each of our functions so that we can easily integrate -- we define operators for each of our functions so that we can easily integrate
 -- them into the current PO search queries -- them into the current PO search queries
Line 44: Line 44:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- This function is exactly like tokenized_ilike,​ but its first argument is integer -- This function is exactly like tokenized_ilike,​ but its first argument is integer
 create function tokenized_ilike(integer,​ varchar) returns bool as ' create function tokenized_ilike(integer,​ varchar) returns bool as '
Line 56: Line 56:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- we define operators for each of our functions so that we can easily integrate -- we define operators for each of our functions so that we can easily integrate
 -- them into the current PO search queries -- them into the current PO search queries
Line 85: Line 85:
 = Version 2.30 = = Version 2.30 =
  
-<​code>​+<​code ​sql>
 -- This function is exactly like tokenized_like,​ but it is case insesnitive -- This function is exactly like tokenized_like,​ but it is case insesnitive
 create function tokenized_ilike(varchar,​ varchar) returns bool as ' create function tokenized_ilike(varchar,​ varchar) returns bool as '
Line 97: Line 97:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- we define operators for each of our functions so that we can easily integrate -- we define operators for each of our functions so that we can easily integrate
 -- them into the curret PO search queries -- them into the curret PO search queries
Line 108: Line 108:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- This function is exactly like tokenized_ilike,​ but its first argument is integer -- This function is exactly like tokenized_ilike,​ but its first argument is integer
 create function tokenized_ilike(integer,​ varchar) returns bool as ' create function tokenized_ilike(integer,​ varchar) returns bool as '
Line 120: Line 120:
 </​code>​ </​code>​
  
-<​code>​+<​code ​sql>
 -- we define operators for each of our functions so that we can easily integrate -- we define operators for each of our functions so that we can easily integrate
 -- them into the curret PO search queries -- them into the curret PO search queries
podoc/tokenized_ilike_sql_function.txt ยท Last modified: 2007/04/23 10:32 by Luud