Roland Martin wrote:
> I have a need to filter the result set before aggregate functions are
> performed.

Use the WHERE clause.

> Unfortunately I cannot query the security system  to find out all valid
> values and add these values to the where clause. I have to give a value to
> the security system and it returns pass or fail.

Add a call to a user-defined function to the WHERE clause.
<http://www.sqlite.org/c3ref/create_function.html>


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to