Hi Sean,
for the return type, I put record and setup a record variable which is returned depending on the input. For the output of the query, all the fields I want in the query are shown means its just a matter of sorting out the composite type out. Most of them are varchars, although there are a few numeric and date fields also.
Ben
On 8/21/06, Sean Davis <sdavis2@mail.nih.gov> wrote:
On 8/21/06 9:31 AM, "ben sewell" <mosherben@gmail.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