PostGreSQL_StoredFunction2
Workflow:
Function show_text1():
code : PostGreSQL_StoredFunction2.txt
-- DROP FUNCTION show_text1();

CREATE OR REPLACE FUNCTION show_text1()
RETURNS text AS
$BODY$
BEGIN
RETURN 'HELLO WORLD'; -- Return the cursor to the caller
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION show_text1()
OWNER TO postgres;
 
PHP client : Querying with select statement
Connection Class:

JDBC SQL query with Select statements
Runt time displays: