User Tools

Site Tools


podoc:tokenized_like_sql_function

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
podoc:tokenized_like_sql_function [2007/04/18 15:03] Luudpodoc:tokenized_like_sql_function [2007/04/23 14:33] (current) Luud
Line 21: Line 21:
 === Schema === === Schema ===
  
-<code>+<code sql>
 -- This function searches for exact matches of 'keyword' in 'string'. -- This function searches for exact matches of 'keyword' in 'string'.
 -- The input 'string' is tokenized by a space, and each token is comapred -- The input 'string' is tokenized by a space, and each token is comapred
Line 81: Line 81:
 </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 92: Line 92:
 </code> </code>
  
-<code>+<code sql>
 -- This function is exactly like tokenized_like, but its first argument is integer -- This function is exactly like tokenized_like, but its first argument is integer
 create function tokenized_like(integer, varchar) returns bool as ' create function tokenized_like(integer, varchar) returns bool as '
Line 104: Line 104:
 </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 133: Line 133:
 = Version 2.30 = = Version 2.30 =
  
-<code>+<code sql>
 -- This function searches for exact matches of 'keyword' in 'string'. -- This function searches for exact matches of 'keyword' in 'string'.
 -- The input 'string' is tokenized by a space, and each token is comapred -- The input 'string' is tokenized by a space, and each token is comapred
Line 193: Line 193:
 </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 204: Line 204:
 </code> </code>
  
-<code>+<code sql>
 -- This function is exactly like tokenized_like, but its first argument is integer -- This function is exactly like tokenized_like, but its first argument is integer
 create function tokenized_like(integer, varchar) returns bool as ' create function tokenized_like(integer, varchar) returns bool as '
Line 216: Line 216:
 </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_like_sql_function.1176908615.txt.gz · Last modified: 2007/04/18 15:03 by Luud