On Sat, Mar 22, 2014 at 3:56 PM, bricklen <brick...@gmail.com> wrote: > On Sat, Mar 22, 2014 at 3:27 PM, Erik van Zijst <erik.van.zi...@gmail.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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
