Postgres Pro
Downloads
Home   >   mailing lists

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

From ben sewell
Subject Function error- A column definition list is required for functions returning "record"
Date
Msg-id bf6c74d80608180815g57bbda59m5369bedc5e0c25a9@mail.gmail.com
Whole thread Raw
Responses Re: Function error- A column definition list is required for functions returning "record"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Glenn Davy
Date:
Subject: Re: Optimal Postgres Development Process, Software
Next
From: "Don Morrison"
Date:
Subject: Use of !~* to keep a varchar column UNIQUE case-insensitive