Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Subquery as a list of values
Maybe you should post the statement you have problems with. I have problems in understanding these example-statements with 'table1' etc. ;)- Taris
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
-
Subquery as a list of values
Try it this way: select field1 from table1 where field1 not in '(select field2 from table2 where field2 like 'something')%'; Be carful with the IN-Clause. Postgres is not very fast with IN-Subselects with Version 7.3 and older versions- Taris
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
Performance Issue
Hello, At the moment I am testing a little bit with PostgreSql 7.4.2. Especially I want to find the "best" indexes for specific SQL-Statements. Let me describe a very strange situation. I execute some SQL-Selects on a table. First, the table is not index. I enter a SELECT-statement that...- Taris
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
