How to use ADT parameter in PgStoredProc?

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
xalion
Posts: 123
Joined: Fri 20 May 2005 10:08

How to use ADT parameter in PgStoredProc?

Post by xalion » 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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How to use ADT parameter in PgStoredProc?

Post by AlexP » Mon 11 Jul 2016 10:28

Hello,

Currently, functions with these parameters are not supported.

Post Reply