Re: Re: postgres C function returning SETOF record gives RECORD TYPE NOT REGISTERED - Mailing list pgsql-novice

From Tom Lane
Subject Re: Re: postgres C function returning SETOF record gives RECORD TYPE NOT REGISTERED
Date
Msg-id 21421.1244157159@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres C function returning SETOF record gives RECORD TYPE NOT REGISTERED  ("raajarshi ." <raajarshi@sify.com>)
List pgsql-novice
"raajarshi ." <raajarshi@sify.com> writes:
> to add a little clarification to the problem description, the transformed
> query (one which is actually run) returns the same result as the submitted
> query so actually the caller knows the number and type of fields to expect
> but they can be different for different calls as any query can be specified
> as the argument of the function.So would I have to create a placeholder type
> for each run of the query or what ??

You might want to look at the way contrib/dblink does this.

            regards, tom lane

pgsql-novice by date:

Previous
From: Bruce Hyatt
Date:
Subject: Yum Update Errors
Next
From: "Larry Silvermintz"
Date:
Subject: Update Triggers accessing new values and intercepting.