On Thu, Jun 26, 2008 at 03:24:41PM -0400, Phillip Mills wrote: > dev=# explain analyze select * from result where active = true; > dev=# explain analyze select * from result where active is true; > This is version 8.2.6. Is there something I'm missing that could make these > queries ever produce different results? As usual the counter example is when there a NULL where the two expressions arn't equal. That this doesn't affect the result of the query is I suppose a deficiency of the expression comparitor... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
