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
--
Dave Barter
Web: http://www.phased.co.uk
Email:[email protected]
Twitter:@Citizenfishy
