Re: [sqlite] User function in WHERE clause

2006-07-28 Thread Stan
O.K. This is what I need. Thanks -- View this message in context: http://www.nabble.com/User-function-in-WHERE-clause-tf2009603.html#a5543377 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] User function in WHERE clause

2006-07-28 Thread Dennis Cote
On 7/28/06, Stan <[EMAIL PROTECTED]> wrote: But there are my problems: 1) Return value xFunc is void? I have to return integer. 2) Where are described parameters in xFunc? E.g. what is it "sqlite3_context"? Stan, Check out section 2.3 User defined funcion s on this page

Re: [sqlite] User function in WHERE clause

2006-07-28 Thread Stan
Thanks for answer. Yes, I have read this many times, but... ...I'm dumb maybe. I understand first 5 parameters in the "sqlite3_create_function". xStep and xFinal will be NULL. But there are my problems: 1) Return value xFunc is void? I have to return integer. 2) Where are described parameters

Re: [sqlite] User function in WHERE clause

2006-07-28 Thread Stan
Thanks for tip. I'm happy to see it's possible. Alas, I'm rather confused. I have read documentation, but I'm not sure what parameters to use and what return value for WHERE clause. Can you be so kind and show me a skeleton (C++) function for this: SELECT * FROM Table WHERE MYFUNC(ColumnName,

RE: [sqlite] User function in WHERE clause

2006-07-27 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 8:33 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] User function in WHERE clause > > "param MYFUNCTION Name" is equivalent to &g

Re: [sqlite] User function in WHERE clause

2006-07-27 Thread drh
"Robert Simpson" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 27, 2006 7:48 AM > > To: SQLite > > Subject: [sqlite] Re: User function in WHERE

Re: [sqlite] User function in WHERE clause

2006-07-27 Thread Jay Sprenkle
On 7/27/06, Stan <[EMAIL PROTECTED]> wrote: Hi, is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. http://sqlite.org/capi3ref.html#sqlite3_create_function

[sqlite] User function in WHERE clause

2006-07-27 Thread Stan
Hi, is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. Thanks Stan -- View this message in context: