Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Array parameter declaration error



&ru wrote:
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.

Fixed in svn, thanks for reporting.

Regards,
Andreas



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group