podoc:tokenized_ilike_sql_function
Database Function Description of "tokenized_ilike"
Name
tokenized_ilike
Description
This function searches for exact matches of 'keyword' in 'string'.
The input 'string' is tokenized by a space, and each token is comapred to the 'keyword'. True is returned if the token fully matches the keyword. If the 'keyword' did not match any of the tokens of 'string' false is returned.
This function is case insensitive.
There is an alternative second version that has an integer as first argument.
Purpose
Searching for keywords.
Schema
-- This function is exactly like tokenized_like, but it is case insensitive CREATE FUNCTION tokenized_ilike(VARCHAR, VARCHAR) RETURNS bool AS ' declare string alias for $1; keyword alias for $2; begin return tokenized_like(lower(string), lower(keyword)); end; ' LANGUAGE 'plpgsql';
-- we define operators for each of our functions so that we can easily integrate -- them into the current PO search queries CREATE operator =##= ( leftarg = VARCHAR, rightarg = VARCHAR, PROCEDURE = tokenized_ilike, commutator = =##= );
-- This function is exactly like tokenized_ilike, but its first argument is integer CREATE FUNCTION tokenized_ilike(INTEGER, VARCHAR) RETURNS bool AS ' declare identifier alias for $1; keyword alias for $2; begin return tokenized_ilike(text(identifier), keyword); end; ' LANGUAGE 'plpgsql';
-- we define operators for each of our functions so that we can easily integrate -- them into the current PO search queries CREATE operator =##= ( leftarg = INTEGER, rightarg = VARCHAR, PROCEDURE = tokenized_ilike, commutator = =##= );
Related functions
History
Used first
Version 2.30
Used last
Still in use
Change history
= Version 2.30 =
-- This function is exactly like tokenized_like, but it is case insesnitive CREATE FUNCTION tokenized_ilike(VARCHAR, VARCHAR) RETURNS bool AS ' declare string alias for $1; keyword alias for $2; begin return tokenized_like(lower(string), lower(keyword)); end; ' LANGUAGE 'plpgsql';
-- we define operators for each of our functions so that we can easily integrate -- them into the curret PO search queries CREATE operator =##= ( leftarg = VARCHAR, rightarg = VARCHAR, PROCEDURE = tokenized_ilike, commutator = =##= );
-- This function is exactly like tokenized_ilike, but its first argument is integer CREATE FUNCTION tokenized_ilike(INTEGER, VARCHAR) RETURNS bool AS ' declare identifier alias for $1; keyword alias for $2; begin return tokenized_ilike(text(identifier), keyword); end; ' LANGUAGE 'plpgsql';
-- we define operators for each of our functions so that we can easily integrate -- them into the curret PO search queries CREATE operator =##= ( leftarg = INTEGER, rightarg = VARCHAR, PROCEDURE = tokenized_ilike, commutator = =##= );
podoc/tokenized_ilike_sql_function.txt · Last modified: 2007/04/23 14:32 by Luud