Re: Error when creating function in psotgresql 8.1

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: ben sewell <mosherben(at)gmail(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Error when creating function in psotgresql 8.1
Date: 2006-08-17 12:45:08
Message-ID: C109DD14.F994%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message ben sewell 2006-08-17 13:13:53 Re: Error when creating function in psotgresql 8.1
Previous Message ben sewell 2006-08-17 12:42:44 Re: Error when creating function in psotgresql 8.1