Hello! I vaguely remember that someone said somewhere that EXISTS runs faster than IN:
SELECT * FROM table1 where field1 EXISTS (SELECT field4 FROM table2) However, all I got from version 7.1.3 is: ERROR: parser: parse error at or near "exists" While below works: SELECT * FROM table1 where field1 IN (SELECT field4 FROM table2) Any key points I have missed? CN -------------------------------------------------------- You too can have your own email address from Eurosport. http://www.eurosport.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
