Forum OpenACS Q&A: Response to some advice on a search...
5: Response to some advice on a search... (response to 1)
Posted by David Kuczek on 10/12/01 01:30 AM
If I had one job in my job_offers table and that job would have ten office_locations, your query would search all ten postal_codes of offers_locations but only one row of job_offers?
Didn't you forget: and lower(title) like lower('%$title%')?
Is there a call to see what exactly postgres is proceding with this search?
What do you mean with: "This won't work if you want to attach list of locations to each row."
What would be the difference if I used group by instead of distinct?