CREATE OR REPLACE FUNCTION transformsinset_FindFor_transformsetid ( v_transformsetid int4 ) RETURNS SETOF int4,int4,varchar(50),varchar(250),int4,float4,datetime AS $$ SELECT transformsetid, transform.transformid, name, notes, pointnumber, radialposition, dateupdated FROM transformsinset, transform WHERE transformsetid = $1 AND transformsinset.transformid = transform.transformID; $$ LANGUAGE sql;