phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From faisal moeen <fmorak...@gmail.com>
Subject WHERE clause behavior
Date Sat, 09 Aug 2014 12:11:25 GMT
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

Mime
View raw message