Re: Postgresq 8,1 hangs when running function

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(at)mail(dot)nih(dot)gov> wrote:
>
>
>
>
> 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
>
>