Skip site navigation (1) Skip section navigation (2)

Re: Error when creating function in psotgresql 8.1

From: "ben sewell" <mosherben(at)gmail(dot)com>
To: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Error when creating function in psotgresql 8.1
Date: 2006-08-17 13:13:53
Message-ID: bf6c74d80608170613i3b4252cdv881c3d16cb06573b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>

In response to

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-08-17 13:23:48
Subject: Re: Error when creating function in psotgresql 8.1
Previous:From: Sean DavisDate: 2006-08-17 12:45:08
Subject: Re: Error when creating function in psotgresql 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group