error:

From: "chetan N" <chetan622(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: error:
Date: 2008-09-29 13:38:50
Message-ID: 24ebf2060809290638t57e73cd4hff5708b739d7a336@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message yann.dubost 2008-09-29 13:41:33 Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?
Previous Message Raymond O'Donnell 2008-09-29 13:26:45 Re: Replication using slony-I