[SQL] Arrays, types and prodedures

Hi

I am having trouble passing arrays of types to a store procedure
I have the following type

CREATE TYPE IndexElement AS (
keyname text,
keytype integer
);

and the header for the store prodedure is as follows:

CREATE OR REPLACE FUNCTION doIndexGroupCount(
indexs IndexElement[],
customerid INTEGER ,
logic INTEGER )

but when I try and call it using the following code

SELECT * from doIndexGroupCount(ARRAY[('dog', 1),('cat', 1)],10,0);

I get and error

ERROR: could not find array type for data type record

What am I missing?

Chris

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql