How to use ADT parameter in PgStoredProc?
Posted: Sun 10 Jul 2016 03:18
wnen I use pgdac,I have a question.
sample:
PG:
CREATE TABLE public.t1 (
f1 INTEGER NOT NULL,
f2 VARCHAR(20),
CONSTRAINT t1_pkey PRIMARY KEY(f1)
)
WITH (oids = false);
CREATE OR REPLACE FUNCTION public.fun1 (
p1 public.t1
)
RETURNS varchar AS
$body$
BEGIN
RETURN p1.f2;
END;
$body$
LANGUAGE 'plpgsql';
Delphi:
in PgStoredProc's "Stored Proc Call Generator", I Input "fun1",
It auto generate "SELECT fun1(:p1)",
but parameter "p1"'s datetype is "ADT",
I don't how to use input parameter "p1".
please give me a example.
thanks.
sample:
PG:
CREATE TABLE public.t1 (
f1 INTEGER NOT NULL,
f2 VARCHAR(20),
CONSTRAINT t1_pkey PRIMARY KEY(f1)
)
WITH (oids = false);
CREATE OR REPLACE FUNCTION public.fun1 (
p1 public.t1
)
RETURNS varchar AS
$body$
BEGIN
RETURN p1.f2;
END;
$body$
LANGUAGE 'plpgsql';
Delphi:
in PgStoredProc's "Stored Proc Call Generator", I Input "fun1",
It auto generate "SELECT fun1(:p1)",
but parameter "p1"'s datetype is "ADT",
I don't how to use input parameter "p1".
please give me a example.
thanks.