Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4VBPhE99292 for ; Thu, 31 May 2001 07:25:48 -0400 (EDT) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f4VBPdh10911 for ; Thu, 31 May 2001 21:25:39 +1000 Received: from buffy.tpgi.com.au(203.12.160.34) via SMTP by bleys.tpgi.com.au, id smtpdHoI6p0; Thu May 31 21:25:35 2001 Received: (from smtpd@localhost) by buffy.tpgi.com.au (8.9.3/8.9.3) id VAA13393 for ; Thu, 31 May 2001 21:25:35 +1000 Received: from bri2-56k-140.tpgi.com.au(203.29.144.140), claiming to be "hnjack" via SMTP by buffy.tpgi.com.au, id smtpdafKMPH; Thu May 31 21:25:22 2001 Message-ID: <000901c0e9c4$4bd843a0$2400a8c0@hnjack> From: "datactrl" To: Subject: question about PL/pgSQL function Date: Thu, 31 May 2001 21:24:31 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/354 X-Sequence-Number: 3195 With postgres 7.1 1. Function like example found on 24.4 Example in Programmer Guide CREATE FUNCTION xxx (EMP, integer) RETURNS boolean AS'...... (which EMP is a table ) How do I pass a record to this function in PL/PGSQL? I try this .... select into rec1 * from EMP where empNo =''xxxx''; i1 := xxx(rec1,5); .... But it won't work! 2. Is that possible to return a record from a function? And how do I get the returned record in PL/pgSql JACK