[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] IN clause performance
From:       Peter Wiersig <peter () friesenpeter ! de>
Date:       2007-07-19 15:42:33
Message-ID: 20070719154233.GC6531 () london087 ! server4you ! de
[Download RAW message or body]

On Thu, Jul 19, 2007 at 05:52:30AM -0700, Paul Codler wrote:
>  Basic query optimization question- does Postgres process
> 
>    x IN (y1, y2)
>  as fast as
>    (x = y1 OR x = y2)
> 
>  in a function?

EXPLAIN indicates this.

Peter

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic