Bug report - Version 1.20.0 REL-1_20_0
| От | Dave Barter |
|---|---|
| Тема | Bug report - Version 1.20.0 REL-1_20_0 |
| Дата | |
| Msg-id | etPan.54edc700.41a7c4c9.1af@iMac.local обсуждение |
| Ответы |
Re: Bug report - Version 1.20.0 REL-1_20_0
|
| Список | pgadmin-support |
Pgadmin cannot cope with default function parameters that are text arrays:-
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json,
prefix_param character varying DEFAULT 'attributes'::character varying,
column_prefixes character varying[] DEFAULT ARRAY['FA'::text,'FT'::text, 'F'::text, 'FTA'::text, 'FH'::text, 'WI'::text, 'WIT'::text, 'WIS'::text, 'WQ'::text, 'A'::text, 'FILTERS'::text]
) RETURNS json as
$$
BEGIN
END;
$$
LANGUAGE PLPGSQL
Displays as:-
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json DEFAULT 'attributes'::character varying,
prefix_param character varying DEFAULT ARRAY['FA'::text,
column_prefixes character varying[] DEFAULT 'FT'::text)
RETURNS json AS
$BODY$
BEGIN
END;
$BODY$
LANGUAGE plpgsql
В списке pgadmin-support по дате отправления: