returning SETOF RECORD

returning SETOF RECORD

Postby bradk » Wed 10 Jan 2007 15:07

We would like to return a SETOF RECORD from plpgsql function, but the Corelab provider throws this exception:

A column definition list is required for functions returning "record"

Is this possible ? We are using the enterprise library provider.
bradk
 
Posts: 34
Joined: Thu 20 Apr 2006 01:42

Postby Alexey » Thu 11 Jan 2007 08:08

Send us small test project if possible to reproduce the problem; include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby bradk » Mon 15 Jan 2007 15:07

I sent some sample code to the e-mail listed in the readme. Please let me know if you received it.
bradk
 
Posts: 34
Joined: Thu 20 Apr 2006 01:42

Postby Alexey » Tue 16 Jan 2007 11:22

I don't think we have received your sample. Please re-send it to me directly (alexeyi at crlab dot com).
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL