A column definition list is required for functions returning record position 15. 但是�...

A column definition list is required for functions returning record position 15. 但是，当我们尝试定义一个返回“record”类型的函数时，有时会遇到“ERROR: 42601：a column definition list is required for functions returning “record””的错误。 错误解读 这个错误消息的含义是，在定义返回“record”类型的函数时，需要明确指定函数返回结果的列定义。 Aug 29, 2016 · In response to Re: a column definition list is required for functions returning "record" at 2016-08-29 11:28:11 from Tom Lane Browse pgsql-general by date Aug 26, 2016 · In response to a column definition list is required for functions returning "record" at 2016-08-26 15:20:37 from Alexander Farber Responses Re: a column definition list is required for functions returning "record" at 2016-08-26 21:55:06 from Merlin Moncure Browse pgsql-general by date Jul 17, 2007 · Then I changed it to return SETOF RECORD, in order to be able to return dataset with varying number of columns. which does not work. > First it was defined to return SETOF someview. The sever has no way to deal with that when the query is parsed and planned, so you have to help it out. Jul 25, 2022 · Please start with the documentation for that feature. FROM () WHERE ()' Feb 18, 2015 · Actually the problem is in another function, where I call transformServers(json). 2. Use RETURN QUERY and UPDATE with a RETURNING clause. > Then I changed it to return SETOF RECORD, in order to be able to return > dataset with varying number of columns. Aug 26, 2016 · Typically should only be used when the function does not have a well defined return structure. pqp xnsr vbqmur saa vadli kvsl xknwe qjvwznf fbaaz wpeqzwb