Re: C Function returning a tuple with a float4 array as column
От | Tim |
---|---|
Тема | Re: C Function returning a tuple with a float4 array as column |
Дата | |
Msg-id | 4CFCE8C4.2030602@comcast.net обсуждение исходный текст |
Ответ на | Re: C Function returning a tuple with a float4 array as column (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: C Function returning a tuple with a float4 array as column
|
Список | pgsql-novice |
Tom, Thanks for the feedback. To clarify, don't need to return multiple rows, just a single row which is a composite type that contains multiple arrays. My apologies for using the incorrect terminology. I have successfully written individual functions to return arrays and to return composites. The function to return a composite type used the SRF functions with a row count of 1. So re-phrasing my question what would the code sequence look like to return a single composite type, that contained 1 or more arrays? regards Tim On 12/5/2010 1:03 PM, Tom Lane wrote: > I wrote: >> ... But what seems likely to be the problem is that >> you've declared the function to return set (that's implied by the >> RETURNS TABLE syntax) but not coded it to do any such thing. I'm >> guessing some piece of code is confused by the function's failure to >> follow the SRF API. > No, scratch that: the problem is with that syntax, but in the columns > direction not the rows direction. Since you've only got one column, > the TABLE syntax degenerates to one OUT param, which is treated as > though it were just the normal function result. IOW, this function > shouldn't be returning a tuple at all, but just the array datum. > > regards, tom lane >
В списке pgsql-novice по дате отправления: