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