<< DbFuzzyLoadFMB SciDb DbFuzzyUpdate >>

SciDb >> SciDb > DbFuzzyQuery

DbFuzzyQuery

executes a fuzzy query using a FuzzySQL object

Calling Sequence

resultHandle = DbFuzzyQuery(fuzzySQL, queryString)

Parameters

fuzzySQL

FuzzySQL pointer object, returned by either DbFuzzyLoadFMB() or DbFuzzyCreateFMB() functions

queryString

A fuzzy query in FSQL language.

Description

DbFuzzyQuery(...) Executes fuzzy query in a FSQL language. Returns resultHandle. The behavior is much the same as one of DbQuery(...) function, but instead dbConnection object a FuzzySQL object is required, and a query is first translated to a raw SQL query from FSQL, and then executed, if it was correct (as for fuzzy object usage).

Examples

// Opens a “PostgreSQL” connection with a structure
connexionStruct          = struct();
connexionStruct.provider = "postgresql";
connexionStruct.database = "myDataBase";
connexionStruct.hostname = "127.0.0.1" ;
connexionStruct.use      = "myUsername";
connexionStruct.password = "myPassword";

DbConnect(connexionStruct);

//creating FuzzySQL object on default connection;
fuzzySQL = DbFuzzyLoadFMB();

//Executing a fuzzy query in FSQL
resultHandle = DbFuzzyQuery(fuzzySQL, "SELECT * FROM Person WHERE Height FEQ $tall THOLD 0.7");

See Also

Authors


Report an issue
<< DbFuzzyLoadFMB SciDb DbFuzzyUpdate >>