Hi, In sqlite3_create_function, xFunc func pointer signature does not allow to have a return value.Any other possible way achieving it apart from collation?
regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: Igor Tandetnik <[EMAIL PROTECTED]> Date: Wednesday, September 5, 2007 8:50 pm Subject: [sqlite] Re: Re: Merging two tables > RaghavendraK 70574 > <[EMAIL PROTECTED]> wrote: > >> How to plug custom search algorthim within Sqlite? > >> For example, > >> > >> select * from table where a = 'xxx'; > >> > >> Instead of using normal inbuilt search can it be userDefined > >> function? > > Yes. You can use sqlite3_create_function to create a function > taking two > parameters and returning a boolean (actually, an integer with the > values > 0 or 1). Then you can say > > select * from table where MyComparison(a, 'xxx'); > > Igor Tandetnik > > > ------------------------------------------------------------------- > ---------- > To unsubscribe, send email to [EMAIL PROTECTED] > ------------------------------------------------------------------- > ---------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
