From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | FW: Array parameter declaration error |
Date: | 2005-11-01 19:24:47 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC3851@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-11-01 19:34:22 | pgAdmin III v1.4.0 Release Candidate 1 released for testing |
Previous Message | MaXX | 2005-11-01 14:00:11 | An annoying problem in SQL Editor, and a realy minor glitch |