On Feb 3, 2005, at 6:31 PM, T- Bone wrote:
> CREATE OR REPLACE FUNCTION "MySchema".tester(int8)
> RETURNS SETOF "MySchema"."tblTransact" AS
> 'DECLARE
> rec RECORD;
> BEGIN
> FOR rec IN SELECT * FROM "MySchema"."tblTransact"
> WHERE "OfferID" > $1
> LOOP
> RETURN NEXT rec;
> END LOOP;
> RETURN;
> END;'
> LANGUAGE 'plpgsql' VOLATILE;
>
Since you are returning a specific table type, try changing the rec
declaration line to:
rec "MySchema"."tblTransact"%rowtype;
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL