function in pgAdmin
От | rwade@uci.edu |
---|---|
Тема | function in pgAdmin |
Дата | |
Msg-id | 8515426deaea8d2477c2cd5ceb3aeb7e.squirrel@webmail.uci.edu обсуждение исходный текст |
Ответ на | Dynamic SQL in Function (rwade@uci.edu) |
Список | pgsql-general |
How do I view the result set of a function that returns a refcursor in pgAdmin? I am trying to test it in pgadmin my calling it like this, but I can't see the result set, it only says: Query result with 1 rows discarded. Query result with 328 rows discarded. Query returned successfully with no result in 32 ms. How I'm calling in pgAdmin: begin; select select_movies_by_web_search('Test', 2008, '', null, null, null); fetch all in moviecursor; commit; Here is my function: CREATE OR REPLACE FUNCTION select_movies_by_web_search(title character varying(100), movieyear integer, director_rest_of_name character varying(50), director_last_name character varying(50), star_first_name character varying(50), star_last_name character varying(50)) RETURNS refcursor AS $BODY$ DECLARE rc refcursor default 'moviecursor'; sql character varying(2000); BEGIN sql = 'SELECT id, title, "year", director_rest_of_name, director_last_name, banner_url, trailer_url FROM movies'; open rc for EXECUTE sql; RETURN rc; END;$BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; ALTER FUNCTION select_movies_by_web_search(character varying, integer, character varying, character varying, character varying, character varying) OWNER TO testuser; Thanks Ryan
В списке pgsql-general по дате отправления: