Forum OpenACS Q&A: Response to some advice on a search...

I am everything but a sql guru, but the only problem that I had with joining the tables was that if some user selected i.e. 10 locations for a job, the rows from job_offers like title etc. would be searched 10 times in case somebody wanted to check out which job had postal_code > x and title = 'whatever'...

Am I wrong here?

Can I avoid postgres to look for the title in all 10 rows (only one would be necessary) while still checking out all rows concerning postal_code?