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
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 |