trigonometric functions in sqlite in iphone sdk

Question

Hi

is there a way to get sine and cosine of a value in sqlite query in iphone sdk? when ever i tried to use sin() in my query sqlite reported that no such function exists.

Any help would be much appreciated!

Thanks Saurabh

Answer 1

SQLite doesn't provide trig functions. The list of scalar functions it offers is here. You can, however, use sqlite3_create_function() to make functions of your choosing accessible to SQL queries.