On Apr 15, 2007, at 3:50 PM, John Siracusa wrote:
> On 4/14/07 1:16 AM, Jonathan Vanasco wrote:
>> 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(?)
>
> See this
On 4/14/07 1:16 AM, Jonathan Vanasco wrote:
> 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(?)
See this thread for some earlier discussion on this topic:
http://www.
On Sat, Apr 14, 2007 at 01:16:10AM -0400, Jonathan Vanasco wrote:
> 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(?)
How about
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 in
