Operator precedence in SQL queries using DB class

[eluser]wcaicedo[/eluser]
Hi friends, i have this question: Is there a way to specify logic operator precedence in a query using those functions available in DB class? Recently i needed something like:

Code:

"SELECT * FROM table where date = $date and (id = $id or other_id = $id)"

But i didn't find a way to specify that using $this->db->or_where() and stuff.

Any ideas? or i'm missing something here..


Thanks in advance.