Re: Bug report - Version 1.20.0 REL-1_20_0

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