All pastes #45065 Raw Edit

Unnamed

public text v1 · immutable
#45065 ·published 2006-03-09 22:15 UTC
rendered paste body
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;