Array parameter declaration error

From: &ru <voros(dot)andras(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Array parameter declaration error
Date: 2005-11-01 09:21:39
Message-ID: a2c1cdef0511010121r301e6b90g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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...)

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Uwe Dalluege 2005-11-01 09:38:21 Re: Hide databases
Previous Message Andreas Pflug 2005-11-01 00:17:22 Re: Hide databases