> select * from attributes_table where id in (select id from > attributes where (name='obsid') and (value='oid00066'));
Can you convert it into a join? 'where in' clauses tend to slow pgsql
down.
--
Mike Nolan
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
