question about PL/pgSQL function

From: "datactrl" <quals(at)bigfoot(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: question about PL/pgSQL function
Date: 2001-05-31 11:24:31
Message-ID: 000901c0e9c4$4bd843a0$2400a8c0@hnjack
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Powell 2001-05-31 15:12:54 7.1 LOCK TABLE changes
Previous Message Richard Huxton 2001-05-31 10:52:48 Re: SELECT * INTO TABLE is not working for me.