Re: Postgresq 8,1 hangs when running function

On 8/21/06 9:31 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:

> 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?

Explain analyze will return the time to complete the query, along with times
for sub-parts of the query. There is no "normal", as it depends on the
complexity of the query, as well as tuning, etc. But 570 ms is 1/2 of one
second, which is probably acceptible.

> 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.

When you actually run the SQL (outside of the function), what is returned?
How does THAT compare to what you asked for?

Sean