Trigonometric functions in sqlite in iphone sdk

Question

Is there any way to get sine and cosine values ​​in sqlite query in iphone sdk? when ever i tried to use sin (), in my query sqlite reported that such a function does not exist.

Any help would be greatly appreciated!

Thanks Saurabh

Answer 1

SQLite does not provide trigger functions. The list of scalar functions that he offers is here . However, you can use sqlite3_create_function () to make your functions available to SQL queries.