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 по дате отправления: