<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hi,<br>
<br>
Does anyone know how to declare arrays of custom types? The
documentation says:<br>
<br>
<blockquote>As discussed earlier, PostgreSQL fully supports arrays of
base types. Additionally, PostgreSQL supports arrays of user-defined
types as well. When you define a type, PostgreSQL automatically
provides support for arrays of that type. For historical reasons, the
array type has the same name as the user-defined type with the
underscore character _ prepended.<br>
</blockquote>
When I run the following code:<br>
<br>
CREATE TYPE TEST_TYPE AS (<br>
ID INTEGER,<br>
CODE VARCHAR(40)<br>
);<br>
<br>
CREATE OR REPLACE FUNCTION Test1( ) RETURNS TEST_TYPE[20] AS'<br>
DECLARE<br>
aoTesttype TEST_TYPE[20];<br>
BEGIN<br>
RETURN aoTestType;<br>
END;' LANGUAGE 'plpgsql';<br>
<br>
CREATE OR REPLACE FUNCTION Test2( ) RETURNS _TEST_TYPE AS'<br>
DECLARE<br>
aoTesttype _TEST_TYPE;<br>
BEGIN<br>
RETURN aoTestType;<br>
END;' LANGUAGE 'plpgsql';<br>
<br>
I get:<br>
psql:Supplements.sql:34: ERROR: Type "test_type[]" does not exist<br>
psql:Supplements.sql:41: ERROR: Type "_test_type" does not exist<br>
<br>
Can anyone help?<br>
<br>
Thanks in advance.<br>
<br>
Matthew<br>
</body>
</html>