Re: Error when creating function in psotgresql 8.1

Hi Sean,
yup it is. I wasn't expecting things to be smooth even if I did know oracle
for the migration. It's handy that there is alot of support if you get stuck
on using it.

One follow up question: as I mentioned before, the procedure is to process
MS Access reports because of how slow JET takes to generate them (some
tables have 7k records). How would I create the report once I've finished
the procedure? I suppose its going to be a VBA coding job after I provide
the execute reports([parameters]) for the View Report button but would like
to know exactly what I need to do after the procedure is done.

Regards,
Ben

On 8/17/06, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
>
>
>
> On 8/17/06 8:42 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:
>
> > Hi Sean,
> > after some debugging of the error messages I managed to create the
> function
> > without any errors. For the record type being returned, it is dependent
> on
> > the report_id so I'll have to add the user defined type in the front end
> > where I execute the procedure.
> >
> > Anyways, I've attached the working script for anyone who is curious to
> see
> > what had to be sorted out. Now I just need to finish off the select
> > statement in the first if and then finish it for the other 4 if's. :)
>
> Ben,
>
> Great to hear you got it working. Postgresql is pretty cool, eh?
>
> Sean
>
>