subject:"\[GENERAL\] IN clause performance"

Re: [GENERAL] IN clause performance

2007-07-19 Thread Peter Wiersig

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)---

[GENERAL] IN clause performance

2007-07-19 Thread Paul Codler

Basic query optimization question- does Postgres process x IN (y1, y2) as fast as (x = y1 OR x = y2) in a function?

[GENERAL] IN clause performance

2007-07-18 Thread Pg Coder

Basic query optimization question- does Postgres process x IN (y1, y2) as fast as (x = y1 OR x = y2) in a function?