Re: [HACKERS] IN(subselect returning few values ...)

2006-11-01 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > Working on 8.1 I've recently been annoyed at the need to translate a > > sub-select inside an IN () clause into a fixed list of contents (the > > results of the sub-select, exactly) in order to get better performa

Re: [HACKERS] IN(subselect returning few values ...)

2006-11-01 Thread Tom Lane
Stephen Frost <[EMAIL PROTECTED]> writes: > Working on 8.1 I've recently been annoyed at the need to translate a > sub-select inside an IN () clause into a fixed list of contents (the > results of the sub-select, exactly) in order to get better performance. Better performance than what? Ever sinc