SETOF RECORD RETURN VALUE
От | Christian Paul B. Cosinas |
---|---|
Тема | SETOF RECORD RETURN VALUE |
Дата | |
Msg-id | 000001c5da18$e1d9ba20$1e21100a@ghwk02002147 обсуждение исходный текст |
Ответ на | Re: converting epoch to timestamp (Stef <svb@ucs.co.za>) |
Ответы |
Re: SETOF RECORD RETURN VALUE
|
Список | pgsql-sql |
Hi I am having some problem with function that returns SETOF RECORD Here is my function: CREATE OR REPLACE FUNCTION test_record(text) RETURNS SETOF RECORD AS $BODY$ DECLARE p_table_name ALIAS FOR $1; temp_rec RECORD; v_query text; BEGIN v_query = 'SELECT * FROM ' || p_table_name; FOR temp_rec IN EXECUTE v_query LOOPRETURN NEXT temp_rec; END LOOP; RETURN ; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; And here is how I execute the function: select * from test_record('field_list') I have this error: ERROR: a column definition list is required for functions returning "record" I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html
В списке pgsql-sql по дате отправления: