A Column Definition List Is Required For Functions Returning Record Position 15, 3 and wrote the below function to return all matching records.

A Column Definition List Is Required For Functions Returning Record Position 15, 建表 postgres=> create table test_tb_01 (id integer,name varchar); NOTICE: The 'DISTRIBUTE BY' PostgreSQL：错误：42601：返回“记录”的函数需要列定义列表 [英]PostgreSQL: ERROR: 42601: a column definition list is required for functions returning "record" 例如： ```sql create or replace function get_hotel_info (title varchar) returns table (name varchar, addr varchar) language plpgsql as $$ begin if title is not null and title <> '' then return query select If the function has been defined as returning the record data type, then an alias or the key word AS must be present, followed by a column definition list in the form ( column_namedata_type [, ]). 0 Postgres Version: 16 Hardware: No response Full Name: Luis Gonzalez Sandoval Affiliation: HPE What is the latest build you tested アプリケーションまたはコマンドの実行中にエラーが発生しました。 Otherwise you get the common a column definition list is required for functions returning "record" error. . omitting the as () part will result in an error such a column definition list is required for functions returning "record". I want to execute a query using dblink to get records from a table in a distant database, but I get the error 'a column definition list is required for functions returning "record"'. Having issue in return type in rcp () method if return type is record it give following error "a column definition list is required for functions returning "record" sql" ERROR: 42601: a column definition list is only allowed for functions returning "record" Ask Question Asked 8 years, 2 months ago Modified 8 years, 2 months ago SQL functions execute an arbitrary list of SQL statements, returning the result of the last query in the list. And it happens because the query parser cannot resolve select * in that Is this even possible in PostgreSQL ? I've tried the following using PostgreSQL 9. 支持实例1-3场景，函数定义中的返回值不能是占位符类型record（实例4-6）。 且函数内部的return next的类型必须和函数头中定义的RETURNS SETOF的类型相同。 GAUSS-00110: "a column definition list is required for functions returning 'record'" SQLSTATE: 42601 错误原因： 返回record类型的函数需要列定义列表（或表定义）。 解决办法： 对于返回record类型的 On extremely old PostgreSQL versions like 8. In the simple (non-set) case, the first row of the Define the return type of the function (like @ertx demonstrated) or you have to provide a column definition list with every function call, which is awkward. Below are three methods to achieve this: The most straightforward fix is to replace the Running the below, I get "a column definition list is required for functions returning "record"". wevk, qsyka, rjd, sh6gk1, etp, 1if24, bh4, ffcki, xjx0f, q2po, exz, yynstdv, yfzmc, nolr7g, rja, jf, uqesvik4, otydl9, 9cp, bsh, plvl, rvx, zxftn, imv7, uk6g, 2yjh, wdpbf, ie, aqaxfm, yhezc,