On Thu, Oct 16, 2008 at 4:40 PM, Stephen Frost <sfrost@xxxxxxxxxxx> wrote: > * Tomasz Ostrowski (tometzky@xxxxxxxxxxxxx) wrote: > I don't see 'limit 1' anywhere in that patch.. And you don't want to > use 'limit 1' *and* count(*), that doesn't do what you're expecting > (since count(*) is an aggregate and limit 1 is applied after). You > really want to do something more like: > > select true from tab1 limit 1; > > And then test if you got back any rows or not (which might be what > *your* patch does, hadn't looked at it yet). > > Thanks, > > Stephen Seems Tomasz linked to the wrong patch. The patch he meant was: http://drupal.org/files/issues/drupal_lookup_path-6.x.patch.txt Or better... he linked to the correct patch (for drupal 5.x) but the user Earnie made a mistake or something in the 5.x patch, seeing the comment[1] that the patches should be the same... Also nice to see people "benchmark" differences by just executing a query once[2][3].... Wessel [1] http://drupal.org/node/196862#comment-648511 [2] http://drupal.org/node/196862#comment-649791 [3] http://drupal.org/node/196862#comment-649928 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
