FW: Array parameter declaration error

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

Hi Andreas,

Can you find 5 minutes to look at this please?

Thanks, Dave

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of &ru
> Sent: 01 November 2005 09:22
> To: pgadmin-support(at)postgresql(dot)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
>