Sorry about missing that (no Postgres on my end). Is there anything you would like me to do?<br><br><br><div><span class="gmail_quote">On 8/21/07, <b class="gmail_sendername">Kevin Falcone</b> <<a href="mailto:falcone@bestpractical.com">
falcone@bestpractical.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>On Aug 21, 2007, at 1:49 PM, Kevin Falcone wrote:
<br><br>><br>> On Aug 20, 2007, at 5:01 PM, Edward Funnekotter wrote:<br>><br>>> Thanks Jesse. I have committed it to the Jifty-DBI trunk<br>>> (r3923). You can now easily limit yourself to a known set of values.
<br>><br>> Unfortunately, the case insensitive IN test fails on Postgres<br><br>Fix coming to a commit-mailing-list near you soon<br><br>-kevin<br><br>><br>> # Failed test 'case insensitive, non-matched case, should find
<br>> two rows'<br>> # at t/01searches.t line 189.<br>> # got: '0'<br>> # expected: '2'<br>> not ok 272 - case insensitive, non-matched case, should find two rows<br>><br>
> -kevin<br>><br>>><br>>><br>>> On 8/20/07, Jesse Vincent <<a href="mailto:jesse@bestpractical.com">jesse@bestpractical.com</a>> wrote: looks<br>>> good. go for it.<br>>> On Aug 15, 2007, at 10:01 AM, Edward Funnekotter wrote:
<br>>><br>>> > Hi all,<br>>> ><br>>> > Here is a patch for your perusal that contains fixes to Jifty-DBI<br>>> > to allow a limit clause to contain an array ref. This gets<br>>> > converted to an 'IN' operator within the built SQL query. The
<br>>> > operator can be either 'IN' or '='.<br>>> ><br>>> > E.g.<br>>> ><br>>> > $users_obj->limit( column => 'login',<br>>> > operator => 'IN',
<br>>> > value => ['cubic', 'obra', 'glasser',<br>>> > 'audreyt'] );<br>>> ><br>>> > Could someone in the know, take a peek and ok the commit?
<br>>> ><br>>> > Thanks,<br>>> > Edward<br>>> ><br>>> ><br>>> > <in_operator_patch.gz><br>>> > _______________________________________________<br>>> > jifty-devel mailing list
<br>>> > <a href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org</a><br>>> > <a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
</a><br>>><br>>><br>>> _______________________________________________<br>>> jifty-devel mailing list<br>>> <a href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org</a><br>>>
<a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a><br>>><br>>><br>>><br>>> _______________________________________________
<br>>> jifty-devel mailing list<br>>> <a href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org</a><br>>> <a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
</a><br>><br>> _______________________________________________<br>> jifty-devel mailing list<br>> <a href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org</a><br>> <a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel">
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a><br>><br><br>_______________________________________________<br>jifty-devel mailing list<br><a href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org
</a><br><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a><br></blockquote></div><br>