Hi Dave,
Definitely looks like a bug. Using the '{}'::character varying[]
format for the array seems to work fine though.
Example;
CREATE OR REPLACE FUNCTION ng_research.test( filter_param json, prefix_param character varying DEFAULT
'attributes'::charactervarying, column_prefixes character varying[] DEFAULT
'{FA,FT,F,FTA,FH,WI,WIT,WIS,WQ,A,FILTERS}'::character varying[]
) RETURNS json as
$$
BEGIN
END;
$$
LANGUAGE PLPGSQL
On Wed, Feb 25, 2015 at 7:58 AM, Dave Barter <dave@phased.co.uk> wrote:
> 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:dave@phased.co.uk
> Twitter:@Citizenfishy