is there a way to get Rose to search based on functions?
ie:
bad
SELECT * FROM useraccount WHERE email = ?
good
SELECT * FROM useraccount WHERE lower(email) = lower(?)
the second query will be optimized by the postgres planner to search
on this index:
CREATE UNIQUE INDEX useraccount_email_uidx ON useraccount(lower
(email));
the first query will do a sequential read.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
