Re: More grist for the PostgreSQL vs MySQL mill

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More grist for the PostgreSQL vs MySQL mill
Date: 2007-01-21 01:14:53
Message-ID: 16887.1169342093@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> On 01/20/07 16:52, Michael Nolan wrote:
>> select plr_rated_memid from tnmt_plr where plr_eventid in ('200607163681');

> Is this query created by an application? I.e, there might be a list
> of PLR_EVENTIDs?

> If so, I understand why it is like it is. Otherwise, why not make
> it a direct equality?

It wouldn't make any measurable difference, I think. The parser folds
it to a simple equality as soon as it notices there's only one ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-21 01:25:31 Re: More grist for the PostgreSQL vs MySQL mill
Previous Message Ron Johnson 2007-01-20 23:17:02 Re: More grist for the PostgreSQL vs MySQL mill