Function error- A column definition list is required for functions returning "record"

From: "ben sewell" <mosherben(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Function error- A column definition list is required for functions returning "record"
Date: 2006-08-18 15:15:20
Message-ID: bf6c74d80608180815g57bbda59m5369bedc5e0c25a9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi guys,
I have this error when I tried testing my function. I set the parameters to
18,2,,,,,,,, as pandctype but it said this error: A column definition list
is required for functions returning "record". I got my UDF setup but I don't
see what the problem is. Can anyone shed any ideas on this?

I've attached my function if anyone wants a look at it.

Cheers,
Ben

Attachment Content-Type Size
reports_sp.txt text/plain 7.7 KB

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Don Morrison 2006-08-18 16:38:03 Use of !~* to keep a varchar column UNIQUE case-insensitive
Previous Message Glenn Davy 2006-08-18 04:34:27 Re: Optimal Postgres Development Process, Software