Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 306A737BABD for ; Mon, 29 Sep 2008 10:38:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46658-03 for ; Mon, 29 Sep 2008 10:38:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id EFC9337B9D3 for ; Mon, 29 Sep 2008 10:38:52 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id c7so693114nfi.23 for ; Mon, 29 Sep 2008 06:38:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=a83R2IIACDQjsfQ1L+XR82vP+/6kX4iGs6s4WzSTwTA=; b=AvxKzLyBJB10UmHJJOqbZAHw1D/GUNVW+1vNSytpnTkobUfgxxmvONqsfAg/eKhAgc btOHHEVrjaRLHRgefFcLLC0O6lNTweDm2CG0+qNzXQ6D5MPl00Xy5Xa3bJxOjQLQTb7B exfU6cE/Ad8BsBjsgZharY0VlUSc9fjKrm0Do= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=i8etPTXb4ioY9GKif+zV4YMzlaaEuM4VkVNmmwZJrH5dUdFTkzmayAfrak+YeTO2yM XTlNoOPD9vqQgtcc1hj7Ps/4lU3ta8ZATHoQ5T//trj2wpc93DrDCb/57b+Nnt8y0YEj +Da1glVEyA7QXQr4OBRHRFBXxVUT32HRUwmDk= Received: by 10.210.46.4 with SMTP id t4mr6237974ebt.152.1222695530757; Mon, 29 Sep 2008 06:38:50 -0700 (PDT) Received: by 10.210.58.19 with HTTP; Mon, 29 Sep 2008 06:38:50 -0700 (PDT) Message-ID: <24ebf2060809290638t57e73cd4hff5708b739d7a336@mail.gmail.com> Date: Mon, 29 Sep 2008 19:08:50 +0530 From: "chetan N" To: pgsql-general@postgresql.org Subject: error: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27042_29266511.1222695530717" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/1136 X-Sequence-Number: 138143 ------=_Part_27042_29266511.1222695530717 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_27042_29266511.1222695530717 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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

------=_Part_27042_29266511.1222695530717--