Hi guys, thanks for the tips. Yup I ran the query with the joins in this time. Explain analyze returned 68 rows this time, in 570 MS. Is the MS time normal?
ok now I seem to be getting somewhere, inputting stuff into my function and now it's saying returned record type does not match expected record type, even thorugh I give the types of the fields in the query. Any ideas? I've checked the fields I am expecting to be returned against what they are stored as in the DB and there are nothing different.
Cheers,
Ben
On 8/21/06, Michael Fuhr <mike@fuhr.org> wrote:On Mon, Aug 21, 2006 at 08:37:21AM -0400, Sean Davis wrote:
> If your SQL from your function has the same behavior when you execute it, it
> is likely one of two problems:
>
> 1) You are doing an unconstrained CROSS JOIN and getting a large result set
Check the parentheses around the OR expressions in the queries'
WHERE clauses. The queries have their join conditions separated
by AND and then an OR that looks like it needs an extra set of
parentheses. That is, instead of this:
AND cond1 AND cond2 AND (cond3 AND cond4) OR (cond5 AND cond6)
try this:
AND cond1 AND cond2 AND ((cond3 AND cond4) OR (cond5 AND cond6))
or
AND cond1 AND cond2 AND (cond3 AND cond4 OR cond5 AND cond6)
Otherwise, as Sean said, you're getting cross joins.
--
Michael Fuhr