Hi Andreas, Can you find 5 minutes to look at this please?
Thanks, Dave > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
