Re: Suboptimal query plan when using expensive BCRYPT functions

On Sat, Mar 22, 2014 at 3:56 PM, bricklen <bricklen(at)gmail(dot)com> wrote:
> On Sat, Mar 22, 2014 at 3:27 PM, Erik van Zijst <erik(dot)van(dot)zijst(at)gmail(dot)com>
>> I could nonetheless take a stab at it, but life would certainly be
>> easier if I could translate each component independently and leave
>> optimization to the query planner.
>
> How about encapsulating the revised query inside a db function? That
> simplifies the query for your query generator to something like "select
> x,y,z from your_func(p_user,p_email,p_crypt)"

I'm not really sure I understand how a db function would make things
easier. What would the implementation for your_func() be and what
would the SQL look like for the DSL example which contains multiple
password checks?

Cheers,
Erik