Re: Replacing a simple nested query? - Mailing list pgsql-sql

Steve Wampler wrote:
> I've got a simple nested query:
> 
>   select * from attributes where id in (select id from
>      attributes where (name='obsid') and (value='oid00066'));
> 
> that performs abysmally.  I've heard this described as the
> 'classic WHERE IN' problem.

I may be missing something, but why can't you just do:  select * from attributes where name='obsid' and
value='oid00066';
?

Joe