[SQL] Stored procedures

[beyaRecords - The home Urban music]

Hi,
I am having problems with a stored procedure (plpgsql) that takes in a value and returns a record set.
my code is as follow:

create function pg_clientRec(text) setof record as
'
declare
customerID ALIAS $1;
rec record;

begin
select into rec * from troubletickets where custID = customerID;
return rec;
end
'
<x-tad-bigger>language 'plpgsql';

I am calling the procedure as follows:

select clientRec('tmpg60');

I am getting the following error:

</x-tad-bigger><x-tad-bigger>ERROR:��set-valued�function�called�in�context�that�cannot�accept�a�set
CONTEXT:��PL/pgSQL�function�"</x-tad-bigger>pg_clientRec<x-tad-bigger>"�while�casting�return�value�to�function's�return�type

What am I doing wrong????


regards

Uzo</x-tad-bigger>