WHERE clause behavior

[faisal moeen]

Hi,

If have a query:

SELECT name
FROM profileTable
WHERE name LIKE 'Ale%' AND *myFunc*(name)=TRUE;

I have  two questions:

1) Can I use *myFunc* in the WHERE clause if my function return boolean.

2) If yes, how would Phoenix translate it into get/scan request. Will it
first use a scan to get all names like 'Ale%' and then apply *myFunc* on
it? Or will it do both requests separately and join the result?

Thanks

-- 

Regards
Faisal Moeen