FW: Array parameter declaration error

Hi Andreas,

Can you find 5 minutes to look at this please?

Thanks, Dave

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of &ru
> Sent: 01 November 2005 09:22
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Array parameter declaration error
>
> OS: Win XP
> pgAdmin III 1.2.1 and 1.4 beta2 and 1.4 beta3
> hungarian language
> binary distribution
>
> I wanted to create a new function with array i/o parameters and the
> SQL command that pgAdmin assembled was this:
>
> CREATE FUNCTION test(v "varchar"[]) RETURNS "varchar[]" AS
> $BODY$BEGIN
> RETURN v;
> END$BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
> and after I applied the dialog form, of course the following
> error occured:
>
> ERROR: type "varchar[]" does not exist.
>
> becouse of the "varchar[]" in the return parameter list
> instead of "varchar"[]
>
> (By the way, why do you use the [] in the SQL commands instead of the
> default _ character? Of course pgsql understands both...)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>