-- Table: "tTest"

-- DROP TABLE "tTest";

CREATE TABLE "tTest"
(
  "iIndex" character( 32 ) NOT NULL DEFAULT ''::bpchar,
  "cName" character varying( 254 ) NOT NULL DEFAULT ''::character varying
) 
WITHOUT OIDS;
ALTER TABLE "tTest" OWNER TO postgres;
GRANT ALL ON TABLE "tTest" TO postgres;
////////////////////////////////////////////////////////////////////////////////////////////////
-- Function: "pTest"(OUT iindex bpchar, OUT cname character varying)

-- DROP FUNCTION "pTest"(OUT iindex bpchar, OUT cname character varying);

CREATE OR REPLACE FUNCTION "pTest"(OUT iindex bpchar, OUT cname character varying) AS
$BODY$SELECT "iIndex", "cName"
  FROM "tTest";$BODY$
  LANGUAGE 'sql' VOLATILE STRICT;
ALTER FUNCTION "pTest"(OUT iindex bpchar, OUT cname character varying) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION "pTest"(OUT iindex bpchar, OUT cname character varying) TO public;
GRANT EXECUTE ON FUNCTION "pTest"(OUT iindex bpchar, OUT cname character varying) TO postgres;

? SQLCONNECT("NewTest")
? SQLEXEC( 1 ,"EXECUTE pTest","aaa")
? SQLEXEC( 1 ,"EXECUTE pTest()","aaa")
? SQLEXEC( 1 ,"EXECUTE pTest('')","aaa")
? SQLEXEC( 1 ,"SELECT pTest()","aaa")
? SQLEXEC( 1 ,"SELECT pTest","aaa")