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 14:48:00
Message-ID: bf6c74d80608170748t3338e1c4s8ebce846b6d4ffef@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-08-17 14:55:41
Subject: Re: Error when creating function in psotgresql 8.1
Previous:From: Jasbinder BaliDate: 2006-08-17 14:19:57
Subject: Re: [NOVICE] DB insert Error

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