Re: Error when creating function in psotgresql 8.1

Hi Sean,
that's fine I'll google it later the time when I need it.

Sorry but I got another question about my procedure, I have my parameters
coming from the access forms which can be left empty (aka null).

I'll need to create handling for when the parameters are null so this would
be using if statements. Once I've handled the input parameters the select
into queries will be run. Here's the pseudocode code for it so I was
wondering if you could tell me the equilivent for it in postgres.

if adviser_id=null then
all records are returned irrespective if the adviser_id
else
find records which the adviser_id matches
endif;

Thanks for your help,
Ben

On 8/17/06, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
>
>
>
> On 8/17/06 9:13 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:
>
> > 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.
>
> I don't use Access, so I really can't answer that. You can try posting
> the
> question again when you get a bit closer to needing that functionality.
>
> Sorry.
>
> Sean
>
>