Hi,
    I am trying to pass array of elements to store procedure, as follows

    CREATE TYPE emptype as(
                                                name text,
                                                id integer,
                                                dob date);

    Function header looks like this

    CREATE OR REPLACE FUNCTION passingEmployeeList(employeeList emptype[])
    RETURNS SETOF employee AS $$

    To execute i am using command

    SELECT * from passingEmployeeList(ARRAY[('chethan', 1,
'10-05-1983'),('ashok', 2, '10-05-1982')]::emptype[] );

    I am getting error as
    ERROR:  could not find array type for data type record


Regards,
chethan

Reply via email to